| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pls help: macro to delete empty rows | Excel Programming | |||
| Delete Empty Rows Macro | Excel Programming | |||
| Delete empty rows with macro by John Walkenbach | Excel Programming | |||
| How do I write a macro to delete all rows from the first empty ro. | Excel Programming | |||
| Cut and Paste macro based on criteria then delete empty rows | Excel Programming | |||
Linear Mode
