Hi,
Well at its simplest you need to preface the loop..end loop instruction with an IF test on the cell which might be invalid. If the test is succesful then the loop will run, if not control will bypass the loop to the End If statement.
In order to advise more I think we need to see the workbook.
Bookmarks