I don't see any new information here (except some misinformation), so unless
I misread it, my code should do what you describe.


A1:i7 transposed to A1:i7. I believe you meant transposed to A1:G9
A8:I14 transposed to A8:I14 I believe you meant transposed to A11:G19


At least that is what my code does. I also understood that you wanted to
process multiple sheets - which I took to mean all sheets except sheet
number 15 in the tab order, writing all their data on sheet number 15 in the
tab order.

--
Regards,
Tom Ogilvy

"Tinkerbell" wrote in message
oups.com...
HI JLGWhiz
I didnt do a very good job describing what Im trying to do I
apologize,
Here is a different aproach.
My data is in a Workbook"CatchAll" Worksheet Sheet1 In col A 1 Thru
Col i 1 (Nine Cols) Down to Col A2401 Col i 2401

I want to copy the first seven rows(A1:i7) on sheet 1 and pastespecial
Transpose To sheet 15 (A1:i7)
Then copy A8:i14 sheet 1 And PasteSpecial Transpose to Sheet 15
A8:I14 Etc Copy and pastespecial Each seven rows Rows down thru
A2401:i2401 Which will resulti 2743 rows total if we leave a blank
row beteween each seven rows.
There is Nine Cols Of data On sheet 1 That I wish to transpose to
sheet 15 seven rows at a time.
Blabbering on like this I must be getting tired.I hope this will be a
little clearer
Thanks Oke Doke