Macro repeats and then stops

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

[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

--
Don Guillett
SalesAid Software
[email protected]
"Sabba Efie" <[email protected]> wrote in message
news:[email protected]...
>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.

[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


"Sabba Efie" <[email protected]> wrote in message
news:[email protected]...
>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.