I want a macro that would copy a row onto a new sheet
transposed and print it. This I can record, I just want
the macro to do it for every line in the work sheet
induvidualy that is the part I need.
I want a macro that would copy a row onto a new sheet
transposed and print it. This I can record, I just want
the macro to do it for every line in the work sheet
induvidualy that is the part I need.
Hi!
Post your macro (or the relevant bit of it) and someone will be able to tell you how to generalise it.
Alf
>-----Original Message-----
>I want a macro that would copy a row onto a new sheet
>transposed and print it. This I can record, I just want
>the macro to do it for every line in the work sheet
>induvidualy that is the part I need.
>.
>Record the macro using relative references, after the
first paste, go back to original sheet, maybe to cell A1
as a reference cell, and drop down the rquired number of
rows and run the body of the macro again. You would need
some sort of counter to detect when all data had been
transferred.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks