View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sanjeev S Sanjeev S is offline
external usenet poster
 
Posts: 2
Default Excel 2002 - Slow macros

Hi All

I am working on a spreadsheet where if a cell doesn't
match a date range the whole row is deleted. The macro
created worked fine in Excel97. However, it can take
anything up to an hour and a half for the macro to
process now. I have tried turning of page breaks, screen
update and automatic calculations but have no luck. Is
this a bug within Excel and is there a work-around?