Type mismatch error with arrays

[heph84]

Hi All,

New to the forums and VBA, and I've got a question about data type mismatches.

Trying to essentially copy and paste values from 6 arrays to 6 different areas. I was trying to use this as an opportunity to try arrays out, but I'm stuck. Any help would be appreciated, and if reasoning could be used I would love to learn more about why this isn't working.

Thank you!

Please Login or Register  to view this content.

[Norie]

You can't refer to variables using something like this.

Please Login or Register  to view this content.

All that ArrRName will contain is the string 'ArrX', where X is whatever value the loop variable I (or II) is.

Same problem with DestName.

This will work but I'm not sure if it'll help your understanding of arrays.

Please Login or Register  to view this content.

[Kaper]

I'd expect first problems here:

Please Login or Register  to view this content.

and more as you go down the code.

ArrName is just a string. (Its value is "Arr1", but it can be anything, it is just a string), while Ubound needs array variable not just a string with this array variable name.

[heph84]

Even the formatting helps me at this stage. I'll google some of the methodology used to get a better understanding (as the saying goestrying to learn to fish, not asking for fish). Thank you for the reply!