Loading...
Uploaded by ExcelVBAHelp on Apr 18, 2009
www.ExcelVBASql.comThis video shows how to fill a 1 dimensional dynamic array (i.e. you don't know the size) and then return the values from the array.
Education
Standard YouTube License
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,
iraninejad 1 month ago
not that easy to follow compared to the first 4 lessons
yumendengdai 6 months ago
Very steep learning curve in these videos. I want to learn, but it would be good to learn to walk before I try flying.
spikypete 6 months ago
Thank you very much.
Can you tell me please why did you write the command
ActiveSheet.Select?
Is it really necessary?
paratatruc 11 months ago
a great work you do by showing us excel VBA, thank you. keep on uploading video please
asmauzum 1 year ago
how about a one-liner:
set myArray = ActiveSheet.UsedRange
mgep090968 1 year ago
too hard, gonna go watch some sitcoms and come back later :P
obesechicken13 1 year ago
Excellent video.... continue !!
caruv28 1 year ago
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.
GMWebb10 1 year ago
@excel201013
It may sound stupid. But could you please tell me what is the use of this or where is this applicable?
victosuf 1 year ago
Load more suggestions
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,
iraninejad 1 month ago
not that easy to follow compared to the first 4 lessons
yumendengdai 6 months ago
Very steep learning curve in these videos. I want to learn, but it would be good to learn to walk before I try flying.
spikypete 6 months ago
Thank you very much.
Can you tell me please why did you write the command
ActiveSheet.Select?
Is it really necessary?
paratatruc 11 months ago
a great work you do by showing us excel VBA, thank you. keep on uploading video please
asmauzum 1 year ago
how about a one-liner:
set myArray = ActiveSheet.UsedRange
mgep090968 1 year ago
too hard, gonna go watch some sitcoms and come back later :P
obesechicken13 1 year ago
Excellent video.... continue !!
caruv28 1 year ago
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.
GMWebb10 1 year ago
@excel201013
It may sound stupid. But could you please tell me what is the use of this or where is this applicable?
victosuf 1 year ago