Some help needed on arrays

[mahmed1]

Hi people

Can anyone of you lovely people help me understand why and when to use transpose with arrays vbvba and what people mean by you can only redim 2nd dimention


just a small data set with some examples would really be appreciated

thank you

 

[mahmed1]

Thank you RoryA

 

[shg]

I have been displaced in Lesceline's affections ...

 

[RoryA]

Not at all, this was merely a brief flirtation.

 

[shg]

Maybe not to Lesceline, you cad.

 

[mahmed1]

I don't mind )))

you both are amazing thank you

based on your experience, when and what types of scenarios would you consider using arrays?

 

[shg]

For a ton of things, LG (I don't type well enough to keep typing that name) -- any time you have a passel of like data.

One common usage is when operating on rows and rows of data -- it's maybe 100 times faster to read the data in once, and operate on it in memory, and write it out once, than reading and writing to a worksheet over and over and over.