Macro repeats and then stops

S

Sabba Efie

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.
 
D

Don Guillett

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
 
T

Trevor Shuttleworth

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
 
Top