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.
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Dryver14

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

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

Well-known Member
Joined
Apr 8, 2009
Messages
17,649
Dryver14,

Thanks for the feedback.

You are very welcome. Glad I could help.

Come back anytime.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,186
Messages
5,594,738
Members
413,929
Latest member
Hypatia

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
Top