Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I've written a custom macro that manually sorts the rows
in my spreadsheet into custom sections. I use the Cut and Paste methods to move rows from the bottom of my sheet to the appropriate section. However, after I run the macro I end up with additional blank rows at the end of the sheet. I tried selecting the rows and deleting them, but they still show up. This causes a problem when printing since the blank rows get included. If I run the macro 10+ times, I end up with thousands of blank lines at the end. Any idea on how to get rid of these blank lines? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Removing blank columns and rows from worksheet | Excel Discussion (Misc queries) | |||
open new blank worksheet with over 65,000 rows | New Users to Excel | |||
How do I insert blank rows between rows in completed worksheet? | Excel Discussion (Misc queries) | |||
Delete ANY blank rows on worksheet | Excel Discussion (Misc queries) | |||
Removing blank rows in a worksheet | Excel Worksheet Functions |