Thanks for the feedback.

Sometimes we do tend to over-complicate some operations and write macros or add
helper columns etc. when not needed.


Gord

On Thu, 31 Aug 2006 10:27:51 GMT, "Francois via OfficeKB.com" <u18959@uwe
wrote:

Gord Dibben wrote:
Select a column and F5SpecialBlanksOK

EditDeleteEntire Row.

Gord Dibben MS Excel MVP

Is it possible either with or without code, to delete all the blank rows in a
worksheet.
[quoted text clipped - 12 lines]

Anita


Thanks Gord,

Such an obviously easy method, but it's saved me a lot of time doing a
similar task

Gord Dibben MS Excel MVP