Hi Guys

I'm pretty clueless when it comes to this, so please bear with me. Basically i have a simple macro which adds/deletes rows of locations in an excel worksheet, one click of the add button adds a row, and one click of the delete button deletes a row. If there is more than one location for a customer, the user clicks add and it inserts a row, and of course vice versa.

I have the row to be copied stored in another worksheet (which I will hide) so that even if all the rows are deleted, I still have the source row, but the problem is that when all the location rows are deleted it starts deleting all the other rows below. The next row after the locations is blank, so is there anything I can insert into the code to stop the macro deleting a row if it is blank?

Thanks
John