Are you actually deleting the row or are you just clearing contents? I find
it odd that rows are just magically reappearing. You should post your code
so we can see what possible problems there are.
--
Cheers,
Ryan


"Code Numpty" wrote:

My Excel 2003 worksheet has rows and columns outside the work area hidden.

I have a macro that deletes rows that do not contain anything in the first
cell and other specific criteria.

When the macro has finished I have new blank rows appearing at the end of
the work area, replacing those that have been deleted, ending with row number
31815.

Is there a way to keep these rows hidden?