Need help with simple Macro
Solved/Closed
Related:
- Need help with simple Macro
- Spell number in excel without macro - Guide
- Hard disk diagram simple - Guide
- Macro excel download - Download - Spreadsheets
- Simple cash book for pc - Download - Billing and accounting
- Automatically run a macro when opening a worksheet - Guide
1 response
Hi Dave,
If I understood your question correctly, you don't need a macro at all to do this.
Here's how you do it.
1. Select all the columns (A1:AN1). Right click and select copy.
2. open a new sheet. Right click on cell A1
3. select Paste Special.
4. Check the box Transpose and press OK.
Thats it. You got the rows and columns transposed.
Hope this helps
Thanks
David
If I understood your question correctly, you don't need a macro at all to do this.
Here's how you do it.
1. Select all the columns (A1:AN1). Right click and select copy.
2. open a new sheet. Right click on cell A1
3. select Paste Special.
4. Check the box Transpose and press OK.
Thats it. You got the rows and columns transposed.
Hope this helps
Thanks
David
Sep 24, 2008 at 12:16 PM
And to think I thought I needed a macro!! I must say I feel a bit stupid right now...
Thanks again!