Hello. How can I loop through the columns in the variables below. I want to offset by 1 column until I reach column H. I think I could do something like i= 1 to and then take the column value of H. Does that make sense?
![]()
Sub ammartino44zz() Dim Copyrange As String Startcol = "c" Lastcol = "H" Let Copyrange = Startcol & 3 & ":" & Lastcol & 3 End Sub For Each c In Copyrange c.Offset(1, 0).Value = c.Value
Bookmarks