Free Excel VBA Course #26 - Using Arrays in VBA

Подписаться 374 тыс.

Просмотров 40 тыс.

50% 1

In this video, I will show you how to work with arrays in Excel VBA.
The video will show you how to work with arrays and combine it with loops to get some advanced stuff done.
✅ Download File: bit.ly/vbacourse-26
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: ru-vid.com...
#Excel #ExcelTips #ExcelTutorial

Опубликовано:

23 мар 2020

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 47

@nisarshaikh 2 года назад

You have greatest teaching skills...amazing and biggest thing is you giving it FREE of cost. stay healthy,stay happy

@sumit7977 2 года назад

yes…its really helpful

@dominicreevantopno6514 3 года назад

Amazingly beautiful language in which you explained the Array with perfect clarity... thanks!

@Copithorne1 3 года назад

Best video I've viewed explaining Excel VBA Arrays. Thanks for including the Excel file.

@nareshkumar9647 Год назад

Awesome explanation of array. You made it simple to understand. Thanks a lot.

@user-iw6tq9nq9h Год назад

Very well explained and great examples. This man is a genius and a great teacher

@trumpexcel Год назад

Thank you so much for the kind words 🙏

@rahillakhan3751 8 месяцев назад

Excellent Tutorial! Thank you.

@amitbhatt5394 2 года назад

beautifully explained....I was in search of such specific video on arrays. Thanks..

@rakeshthakur9403 Год назад

Really very nice video

@Aula-hd7dv 2 года назад

This video is super useful, I appreciate it very much, keep doing these videos. Thank you.

@trumpexcel 2 года назад

Glad the video helped :)

@mikedeboer 2 года назад

This helped me greatly with my understanding of arrays. Thank you.

@marcellosulas1302 3 года назад

Thank you bro. Very clear and concise the way you explained. I had an issue which you just resolved! I have Subscribed

@margad-erdeneboldbaatar4704 2 года назад

Thanks so much.

@manishkumarchd 3 года назад

Thank you Sumit for detailed information.;

@68team 2 года назад

A lot thankyou, Now have no doubt in array ✅

@franciskiap4552 3 года назад

Thankyou sir for this detailed video of using arrays in vba.

@chriswietlispach1498 2 года назад

nicely done!

@veebee3969 3 года назад

Very good video. Thank You.

@mtotowamungu8259 4 года назад

Very well explained, thank you very much.

@trumpexcel 4 года назад

Glad you found the video useful!

@EngineerNhu 4 года назад

Hello sumit.. i am your no. 1 fan, can you make tutorial of the difference between Row, Rows, column, columns, Cell, Cells, worksheet, worksheets. etc .. thanks you so much

@tanjidirfan4833 3 года назад

Excellent Video

@rakeshthakur9403 Год назад

Nice video

@abdullahmersal8423 2 года назад

god bless you man 💕

@Vinmam1231 2 года назад

Stay blessed sir

@jk501111 3 года назад

From my understanding at approx 7:00 the best practice is to Erase CompanyName i.e. erase the array variable. Erase acts much like Unload Me.. although, it may not be a big deal, it's supposed to release memory. Thank you for the tutorial!

@vijaysahal4556 4 года назад

good 👍👍👍👍

@alializadeh8195 2 года назад

Thanx

@richardgreves6161 4 года назад

Thanks Sumit. This is awesome! I have a question though. You used two separate loops. One for reading the data from the sheet and another for writing the data to a different area. Couldn't you have done both in the same loop?

@callanrafael1658 3 года назад

i know I'm quite randomly asking but do anybody know of a good place to watch new tv shows online?

@naiduvikas202 2 года назад

Hi great videos and crystal clear Could please 🙏 solve the this error Dim j as variant, J= Array(cells(1, 10), cells(1, 20)). When watch this code in local window getting typescript error could please help me out of error.

@vedpatel3231 4 года назад

Good but you should make a video about the functions before you use it (e.g redim)

@tansinghrathore4572 3 года назад

Can you please explain how to use array of array in VBA? this is my logic. i have multiples arrays that stores rows value like arrRow1 ,arrRow2 ,arrRow3 so now i want to store these arrays in a one array that is arrTable[arrRow1 ,arrRow2 ,arrRow3]. If I want to access any value then I'll use arrTable[0][1]:- 0 for arrRow1 and the one for the arrRow[1] how its possible in Vba.

@archanaaa2514 4 года назад

Sir, is Vba still in demand in 2020?

@nadermounir8228 4 года назад

In the offset u mention it is not clear where the negative sign comes from. If we use 1,0 then 2,0 etc so why do u write -1 ? May please clarify this part ? This is also repeated when using offset. dimension 1 and dimension 2, -1 was also used 🤔🤔

@mohammadirkanansari671 3 года назад

sir you great but if you are indain please take hindi audio for indian please 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏

@akheeshkm8969 2 года назад

I am unable to pay you from India. I have some queries on array. How can I contact you?

@RobertBCarl 3 года назад

Well explained, however the graphics are barely legible.

@umamaheshk6151 3 года назад

sir, I have some doubts. How can I reach you?

@nadermounir8228 4 года назад

In minutes 10 u used offset (counter -1,0) . Why dit u use -1. It is not clear really?

@bhoopeshsharma9100 3 года назад

here range ("a2") is activecell and In offset (x,y) here x = 1,y=1 means lower bound element start from 1 Then range ("a2"). offset (1,1). value will be store in range ("b3") as "Sinopec" so this will be wrong Now here we want to store value in range ("a2") then we need (-1) bcz here lower bound element start from 1 not from 0 If lower bound element from 0 then No need minus1(-1)

@ishrafilansari2241 3 года назад

Sub arrays() Dim names() As String Dim dimensions1 As Long Dim j As Long dimensions1 = Range("a1", Range("a1").End(xlDown)).Cells.count ReDim names(1 To dimensions1) For j = 1 To dimension1 names(j) = Range("a1").Offset(j - 1, 0).Value Next j End Sub sir i am face very problem to solve this dyanamic array please help me

@ishrafilansari2241 3 года назад

please help to solve this problem

@vipinsingh075 Год назад

@@ishrafilansari2241 the only thing wrong in this code is that you have not used proper variable in the line For j = 1 To dimension1 it should be For j = 1 To dimensions1 you were missing an "s" just before the Dimensions.