column to row macro
No loop is needed:
Sub Steve()
Dim n As Long
n = Cells(1, Columns.Count).End(xlToLeft).Column
Range(Cells(1, 1), Cells(1, n)).Copy
Range("A2").PasteSpecial Paste:=xlPasteAll, Transpose:=True
End Sub
--
Gary''s Student - gsnu200906
"Steve" wrote:
morning all.
I have a text document that I've imported to Excel. It's on one row, across
approximately 1000 columns. I.e., out to AXD.
I need to move the cell contents for each into a single column-- A.
I'm thinking something along the line of-
dim i as integer
while activecell.value<""
select.offset(0,i).cut
select.offset(1,-i).paste
loop
Your helps are appreciated.
Thank you.
|