VBA Lesson 5 - 1 Dimensional Dynamic Array - ExcelVBASql.com 25+ hours of FREE training!

[iraninejad]

so simple so powerful! I am an absolute beginner in VBA but I managed to write the macro that I was trying to write for long time ago just with help of your training video.

thanks a lot mate,

[yumendengdai]

not that easy to follow compared to the first 4 lessons

[spikypete]

Very steep learning curve in these videos. I want to learn, but it would be good to learn to walk before I try flying.

[paratatruc]

Thank you very much.

Can you tell me please why did you write the command

ActiveSheet.Select?

Is it really necessary?

[asmauzum]

a great work you do by showing us excel VBA, thank you. keep on uploading video please

[mgep090968]

how about a one-liner:

set myArray = ActiveSheet.UsedRange

[obesechicken13]

too hard, gonna go watch some sitcoms and come back later :P

[caruv28]

Excellent video.... continue !!

[GMWebb10]

Nice but can you put the code in the comments or somewhere so we can copy it then edit instead of spending 20minutes trying to recreate it.

[victosuf]

It may sound stupid, But I could not get why or what is the use of this in a daily life. Where is this applicable?

[excel201013]

Static array should have taken first as a an example. If you divide this lesson into two parts, will help to learn 1 dimensional array better

[victosuf]

@excel201013

It may sound stupid. But could you please tell me what is the use of this or where is this applicable?

[moneycrab]

you were talking too fast i couldn't follow this video at all.

also why are you using 2003?