Next step in vba learning - Arrays

[Dryver14]

Good afternoon all,

I am now fairly confident with several elements of VBA and get small programmes to do most of what I am trying to do, I've gone from only looping to filtering and think Arrays are the next step.

I'm struggling to understand why we dim an array and then redim.

To be honest no matter how fast I run at the wall head first none of it s sinking in, it's pretty depressing really.

Any good sites out there to talk a simpleton through it.

 

[hiker95]

Dryver14,

See if anything below will help you.

Arrays
Excel: Introduction to Array Formulas - Xtreme Visual Basic Talk
Array in Excel VBA
VBA Arrays

Array Dimensions in Visual Basic - Working with Dimensions (code and graphics)
Array Dimensions in Visual Basic

 

[Dryver14]

Thanks for taking the time hiker,

I will look through them this evening,

I'll let you know how I get on in due course.

 

[Dryver14]

hiker,

Just to say thanks again,

I found most of those sites brilliant, unusually, Chip Persons site is the hardest to fathum but I have a feeling I should have taken a step back on the site.

The visual basic talk site was by far the best with a real step by step introduction to array formulas,

I recommend it to anyone starting on Arrays.

Cheers,
Kev

 

[hiker95]

Dryver14,

Thanks for the feedback.

You are very welcome. Glad I could help.

Come back anytime.