View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] terry.hodgkinson@encodasystems.com is offline
external usenet poster
 
Posts: 1
Default VBA Macros in Excel

I have several VBA macros that were written for Excel 2000
and worked successfully. I have just had my laptop
upgraded to Office 2003 and find that macros are now
running like a dog. Scanning a 1200 line spreadsheet and
hiding any rows with no entry in a specific column took a
couple of seconds. It looks like it now takes about 1
second to parse a single line i.e. 20 minutes for the
complete worksheet. Any ideas why? Any help gratefully
appreciated.

regards
Terry