Next step in vba learning - Arrays

Dryver14

Well-known Member
Joined
Mar 22, 2010
Messages
2,396
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.
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
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.
 
Upvote 0
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
 
Upvote 0
Dryver14,

Thanks for the feedback.

You are very welcome. Glad I could help.

Come back anytime.
 
Upvote 0

Forum statistics

Threads
1,214,275
Messages
6,118,622
Members
448,843
Latest member
Jared016

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top