| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I create a macro to identify and delete blank rows in a range?
I have a report that a customer sends me via e-mail. It is a text file and
so to get it to the point of use I have to manually delete all of the blank rows. Can I create a macro to identify and delete all of the blank rows within this range of data. The files can be up to 10,000 lines of data and every other or every two rows need to be deleted. It takes forever! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to delete blank rows in a data range | Excel Discussion (Misc queries) | |||
| Delete blank rows Macro | Excel Discussion (Misc queries) | |||
| Delete blank rows in Excel with macro | Excel Programming | |||
| Macro to delete blank rows | Excel Programming | |||
| macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Threaded Mode
