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

--
Don Guillett
SalesAid Software

"Sabba Efie" wrote in message
...
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.

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


"Sabba Efie" wrote in message
...
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.