![]()
Sub Transposer() Dim col As Long With Range("A1").CurrentRegion For col = 2 To .Columns.Count .Columns(col).Cut Destination:=Range("A" & Rows.Count).End(xlUp).Offset(1) Next End With End Sub
![]()
Sub Transposer() Dim col As Long With Range("A1").CurrentRegion For col = 2 To .Columns.Count .Columns(col).Cut Destination:=Range("A" & Rows.Count).End(xlUp).Offset(1) Next End With End Sub
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks