If you put

Debug.Print Selection.Address

In your code, it will print the Selection.Address in the Immediate window.
You can access the Immediate window with CTRL G. You can also step through
your code line by line with F8 or put a breakpoint in with F9 and run to the
breakpoint. It helps with debugging the code.
--
HTH,
Barb Reinhardt



"salgud" wrote:

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?