MyFlight
Technical User
- Feb 4, 2002
- 193
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.
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.