Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Help,
I have a Large workbook running multiple Macros to import, compare and generate reports. The Problem is that after all is said and done I endup with a workseet that has about 5000 rows, when only maybe 1000 have data in them. The other 4000 are blank, I nned to remove these as they increase the size of the workbook exponentially. Since this worksheet has between 7 and 10 worksheets with the same problem. Since I am deleting alout of rows I am also worried about the Macro slowing down too much. I already have Application.ScreenUpdating = False Any Ideas or suggestions. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can i delete unused row and columns ??? | Excel Discussion (Misc queries) | |||
I have 4000+ rows in a worksheet, how to delete 100's at a time? | Excel Worksheet Functions | |||
How can i randomly select 780 rows from 4000 rows of data | Excel Worksheet Functions | |||
VB Code to Delete Unused Rows | Excel Programming | |||
How can I insert 4000 rows of Excel data into a sql database | Excel Programming |