Simplest solution I know
Highlight the cells of the array
Copy
Place cursor at location for top left of new array
Paste - Special - Select transpose
And voila - its done
Doncam
"J.Kearney" wrote in message
...
Anyone know (have) a function or macro to relocate entire arrays
from rows to columns?
Thanks in advance.
Joe
|