On 13/10/2011 15:31, Mike wrote:
Hi everyone,

Can someone please refer me to an example on how to use WHILE and LOOP
in Excel's VBA?

Thanks,
Mike

DO WHILE/UNTIL condition
something
LOOP

or

DO
something
LOOP WHILE/UNTIL condition

or

WHILE condition
statements
WEND

F1 on the keyword should get you syntax related help on a good day.

Regards,
Martin Brown