| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete all blank rows...
I have a spreadsheet with over 46,000 rows. around half are blank. I need to
remove all these blank rows, so I can add about 30,000 more. The problem is this....the rows are not really blank. They have expressions in those cells that, when calculated, solve to "". The length of the string is 0, but there is still an expression there, so I am assuming that is why none of my functions/vba have worked so far. Any ideas? I don't care if the solution is DeleteAllEmptyCells or DeleteEmptyRows, or whatever. I'm stuck. Thanks for the help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete ANY blank rows on worksheet | Excel Discussion (Misc queries) | |||
| How can I remove multiple (hundreds) of blank rows in one step? | Excel Discussion (Misc queries) | |||
| Subtotals including blank rows | Excel Discussion (Misc queries) | |||
| Sort Macro to Exclude Blank Rows? | Excel Worksheet Functions | |||
| How do I delete blank rows at the bottom of a spreadsheet to get . | Excel Discussion (Misc queries) | |||
Threaded Mode
