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.