Macro repeats and then stops

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two columns of data. I have written a macro to operate on the data
from the first column (i.e. copy, paste, move cursor, etc.). I want that
macro to repeat for the data in column 1 as long as there is data in column
2. When a blank cell in column 2 is reached the macro should stop.
 
as ALWAYS, post your code for comments but something along this idea
lr=cells(rows.count,2).end(xlup).row
for i=2 to lr
do your thing
next i
 
One way:

i = 1
Do While Range("B" & i) <> ""
MsgBox Range("A" & i).Value
' Replace the MsgBox line above with a call to your macro
' For example:
' YourMacro
i = i + 1
Loop

Regards

Trevor
 
Back
Top