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

(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
'
Range("F2:G8").Select
Selection.Copy
Range("H2").Select
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 *