Macro to delete blank rows in a worksheet
Do you need a macro?
Select a column with the blank rows and F5SpecialBlanksOK
EditDeleteEntire Row.
Gord Dibben MS Excel MVP
On Fri, 20 Mar 2009 13:44:01 -0700, adchris
wrote:
I am attempting to create a macro that will eliminate blank rows from a tab
in a worksheet. I need to do this in order to maintain the "auto-complete"
functionality.
|