Hi,
i am creating a loop based on Row in column A. I am trying to do this with integers.
Basically i have in Column A1 to A500 all kind of users.
A1 Stephan
A2 Bob
A3 Mose
etc
I want to copy from the same row AG:AO to other sheet or do some action.
I dont know how to bind this Integer into the Range or string.
Dim iRow As Integer
Dim iCol As Integer
Dim iEndCol As Integer
Dim wb As ThisWorkbook
Dim ws As Worksheet
iRow = 2
iCol = 33 ' AG
iEndCol = 41 'AO
Do While Cells(iRow, 1) <> ""
' now here i want the iRow into the string
'Range("AG2:AO2").Copy But the 2 should be Irow in the string
'Sheets("Data Fetched").Range("AG: & iRow" & "AO: & iRow").Copy
'perhaps;
Sheets("Data Fetched").Range(Cells(iRow, iCol), Cells(iRow, iEndCol)).Copy
iRow = iRow + 1
Loop
Bookmarks