T
terry.hodgkinson
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
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