Looping
 

do until activecell=""
some lines of code here
activecell.offset(1,0).select
loop

or MUCH faster with a selected range

for each rng in selection
some lines of code here
if rng ="" then
some lines of code here
end if
next rng


Darrel wrote in message
...
I would like to execute my macro until it encounters an empty cell. How
can I check for an empty cell in a macro?