| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to delete blank rows in a data range
Thank you very much, it"s nice and simple and was very helpful to me.
Diana Vazian "Gord Dibben" wrote: Without a macro...........Select a column and F5SpecialBlanksOKEditDeleteEntire Rows Gord Dibben MS Excel MVP On Fri, 28 Mar 2008 08:17:01 -0700, Youlan wrote: Hi, I'm using Excel 2002 and I'm working in a spreasheet with data copied from an external source. I need to automatically delete the blank rows without having to go through the entire document. Also their is no set format to when and how many blank rows are in the document. Can anyone help? Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| reformating data- how to delete alternate blank rows quickly | Excel Discussion (Misc queries) | |||
| How do I delete blank rows (rows alternate data, blank, data, etc | Excel Discussion (Misc queries) | |||
| MACRO HELP - deleting rows containing a range of blank cells | Excel Discussion (Misc queries) | |||
| delete rows in range - macro | Excel Worksheet Functions | |||
| Delete blank rows Macro | Excel Discussion (Misc queries) | |||
Threaded Mode
