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.