Hi Paul,



Thanks for this extensive code.

When I run this code: its gives the run time error - 5991 - cannot access individual rows in this collection because the table has vertically merged cells.

PS - When I click on debug --- it stop to execute code (as expected) and highlights the sentence in the code (as expected again), indicating the possible source of error.

However, when I click on End - it delete the rows with zero.

So with my limited knowledge may be there is a need to include exception handling or something. Anyways I am just guessing.

Mate also I wanted to ask you, which is the best source for beginners to learn all this. You seem to have so much knowledge, its awesome and quite amazing.

Do you also have forums for excel?