C
Click
How do I swop rows for columns in an Excel or Word table?
R
Ragdyer
Select the range (rows or columns),
Right click in the selection and choose "Copy",
Right click in the first cell of the new location and choose "PasteSpecial",
Click on "Transpose", then <OK>.
Make sure there's *no* overlap of old and new ranges.
Right click in the selection and choose "Copy",
Right click in the first cell of the new location and choose "PasteSpecial",
Click on "Transpose", then <OK>.
Make sure there's *no* overlap of old and new ranges.
A
Ardus Petus
To swap col B and C:
Columns("B:B").Cut
Columns("D
").Insert Shift:=xlToRight
HTH
Columns("B:B").Cut
Columns("D
").Insert Shift:=xlToRightHTH