Using an array to add row names

[mcinnes01]

Hi,

I want to put my row headings in using an array, I tried with the following but it just puts "staff details" in every row.

Please Login or Register  to view this content.

[RichardWinter]

Maybe there are more elegant solutions, but this should do the job:

Please Login or Register  to view this content.

[barryleajo]

Hi mcinnes01
I'm still learning array techniques too so can't be forthcoming with a more full explanation.
I think it is to do with trying to copy a horizontal array into a vertical range.
It thus needs to be transposed or as Richard suggests, use a loop.
Use this as a second idea?

Please Login or Register  to view this content.

[Colin Legg]

I think it is to do with trying to copy a horizontal array into a vertical range.

Yes, exactly so. In VBA, a one dimensional array is horizontal, not vertical.

[barryleajo]

@Colin
many thanks, your previous 'tutorial' has rubbed-off a little, and this helps even more
you are the man!

[mcinnes01]

Thanks got it to work

Please Login or Register  to view this content.