VBA Run Macro through worksheets.

[Spacebar]

Hi All.

My first attempt at a macro, basically it Transposes the data from 2 rows, a1:a14 and b1:b14, into 2 columns but I have x amount of worksheets that I need to run the macro.

TS.JPG

I have tried several ways to do this simple task but it just wont work.

Thank you.

Spacebar.

[stnkynts]

Based upon your macro it looks like you want to copy A1:M2 and transpose starting at cell A3. This is completely contradictory from what you stated in your post. Please clarify what you want.

[Spacebar]

Apologies.

stnkynts, you are correct, I want to copy A1:M2 and transpose starting at cell A3.

Then repeat this macro across all the worksheets which there are over a hundred.

Many thanks.

Spacebar.

[stnkynts]

Try:

Please Login or Register  to view this content.

[Spacebar]

Thanks stknynts.

Worked a treat, on an upward learning curve again.

Spacebar.