AD, BB, now BZ,

In any event, the code ran fine for me. It produced about 7 columns of data
*before* it transposed it.

My question was meant to find out how many rows of data you had before the
transpose - since you said it failed at that point.


I can't guess what you have on your sheet, so there isn't much I can say.

--
Regards,
Tom Ogilvy





"Jako " wrote in message
...
I have four rows and the data runs to column BZ.

Thats why i wanted the array heading to go vertically by row.


---
Message posted from http://www.ExcelForum.com/