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

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
23,954
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Apr 18, 2009

www.ExcelVBASql.com

This 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.

Category:

Education

Tags:

License:

Standard YouTube License

  • likes, 1 dislikes

Link to this comment:

Share to:
see all

All Comments (15)

Sign In or Sign Up now to post a comment!
  • 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,

  • not that easy to follow compared to the first 4 lessons

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

  • Thank you very much.

    Can you tell me please why did you write the command

    ActiveSheet.Select?

    Is it really necessary?

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

  • how about a one-liner:

    set myArray = ActiveSheet.UsedRange

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

  • Excellent video.... continue !!

  • 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.

  • @excel201013

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

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more