you'll need to start the loop where you want it to start and end it where you
want to end it (obvious statement). i'd use code similar to the following in
your code:

do
do while range("A2")<""
'here's your looped code
'at the end of your code where you want the loop to end
loop
loop until range("A2")=""

make sure you're doing something with range A2 in this loop or else it will
run forever.

hope this helps,
chad


"AVB Over My Head" wrote:

How can a make a loop in a macro until A2 = blank or "". Where can I
put it in the code, in the beginning of the code or the end of it?