(Solved) – Excel VBA – Macro that runs for entire range of cell


I have this below macro code that performs a transpose a range of cells.

Sub Macro45()
' Macro45 Macro
' r3
' Keyboard Shortcut: Ctrl e
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
    False, Transpose:=True
End Sub

I am trying to see how could I repeat the same process for entire range of rows. My dataset has about 10000 rows and I want to perform the same tasks over the entire range.

Leave a Reply

Your email address will not be published. Required fields are marked *