On Wed, 23 Apr 2008 11:50:01 -0700, Barb Reinhardt wrote:

It appears to me that you're trying to transpose 65526 rows x 256 columns (in
Excel 2003) to 65526 Columns x 256 Rows and it won't do that. Put in a
bunch of debug.print statements to figure out where it's going haywire. I'm
guessing it's in the lines with XLToRight and XLDown.

Thanks for your reply. I should have been clearer. It's not the paste after
the "transpose" that's giving me the problems, it's the one further down
where I'm pasting from cells A1 to A4 into the new workbook.
Sorry about my ignorance, but I don't know what a "debug.print" statement
is or how to use it. What is it? What does it do? How would I use it here?