Delete Empty Rows Macro
 

I am trying to create a code that will delete every empty row from A1:L200.
More specifically, if any cell from A1:L200 has contents in it, I dont want
the row that cells belongs in to be deleted. Is that possible?

Delete Empty Rows Macro
 

You can start here
http://www.rondebruin.nl/delete.htm

Below the first macro you can read what you must replace to delete empty rows

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Workbook" wrote in message ...
I am trying to create a code that will delete every empty row from A1:L200.
More specifically, if any cell from A1:L200 has contents in it, I dont want
the row that cells belongs in to be deleted. Is that possible?

Delete Empty Rows Macro
 

Fantastic! I will spend some time with these and let you know how it turns
out. Thank you for your help.

"Ron de Bruin" wrote:

You can start here
http://www.rondebruin.nl/delete.htm

Below the first macro you can read what you must replace to delete empty rows

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Workbook" wrote in message ...
I am trying to create a code that will delete every empty row from A1:L200.
More specifically, if any cell from A1:L200 has contents in it, I dont want
the row that cells belongs in to be deleted. Is that possible?