Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting All Empty Rows
I am using a macro already recorded, and the only thing I wish I could do
away with is this: When all of the data is brought in and formatted, there are thousands of extra empty rows that exist at the bottom of the document. I want to find a quick way to delete those then automate it, so the macro does it for me. OR Is there a way to sum an entire column automatically within a macro so that the total ends up at the bottom of the columns with values in them. Currently with the thousands of extra empty rows, totalling the column makes the sum appear way at the bottom of the document on line 6,000 something. Thanks!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete empty rows from print in Excel | Excel Worksheet Functions | |||
Deleting All Rows for Duplicate Entries Except Those With Most Items In Row | Excel Discussion (Misc queries) | |||
Deleting and only viewing selected rows | Excel Discussion (Misc queries) | |||
Deleteing empty rows | Excel Discussion (Misc queries) | |||
Deleting rows containing common data | Excel Discussion (Misc queries) |