strings and arrays

when I use the first myArray below this macro outputs a message box that tells me all the values I put into the array, however when I try to read some strings into the array from range A14 to A21 (sheetnames to look for), the code errors at the line: msgString = msgString & myArray(z) & vbCrLf

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Leith are you talking about AB33's solution?

I thought your code worked with a single dimensional, but not when you assign a range in to an array.
If you assign(Load) a range in to an array, by default it is a 2- dim though you may only have a single column.

Originally Posted by Leith Ross

Hello intotothewild,

To answer your question, it was your code that I ran. the only thing I did was change the name of the worksheet that is activated since I don't have a worksheet by that name. Other than that change, the code ran without error.

That is odd, ive got no idea why.


Tom, that's interesting, looks like the array only reads the first two values horizontally but them all when the vector is horizontal. Bit that I don't understand is why it didn't return the first two values in that case (I just got an error).