View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
VexedFist[_2_] VexedFist[_2_] is offline
external usenet poster
 
Posts: 18
Default Delete Unused (4000) Rows

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.