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

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,889
Messages
5,834,257
Members
430,271
Latest member
Jkor

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