how to code to delete empty rows

[hex6007]

Hi guys,

Please help, i want to create a macro in excel, a button that would erase all empty rows.

thanks in advance

 

[MichaelRed]

erase <> delete.



MichaelRed

 

[SBerthold]

they must mean "delete", if the rows are empty

 

[HarleyQuinn]

I'd agree thread707-1528774

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[MichaelRed]

yes, but there is some obvious confusion ...

this is MS Databases ... referncing Excel and Macro?

suggests the thread might belong in the vba forum?





MichaelRed

 

[SBerthold]

> i want to create a macro in excel

Though they asked in the Says a macro in Excel

Therefore, it would classify as a VBA question and should be asked in forum707 as HarleyQuinn pointed to.