Recommendations on understanding arrays

spydey

Active Member
Joined
Sep 19, 2017
Messages
314
Office Version
  1. 2013
Platform
  1. Windows
So I have a project that I am going to start. I will be writing the code in VBA, to automate some manually processes that I do.

Just looking at my data, I think that the best approach is going to involve using (an) array(s). I don't have too much experience using them. Once provided to me I can break it apart and understand it, but coming up with it on my own is what is proving to be a challenge currently.

I think that it is in part due to my lack o understanding them.

Thus, before I request assistance, I would like to get a bit more understanding under my belt regarding arrays in VBA.

Do any of you have any good information, sites, literature, reads, etc., that you can recommend regarding the concept of, use of, implementation of, and understand of arrays in VBA?

I like to try and understand things prior to asking for help .....

Thanks and I look forward to some good reading material!!

-Spydey
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Forum statistics

Threads
1,224,823
Messages
6,181,183
Members
453,020
Latest member
Mohamed Magdi Tawfiq Emam

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