Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 macros - how to merge 5 macros together into one | Excel Discussion (Misc queries) | |||
Training: More on how to use macros in Excel: Recording Macros | Excel Worksheet Functions | |||
Making excel macros run Word macros | Excel Programming | |||
Macros not appearing in the Tools Macro Macros list | Excel Programming | |||
Suppress the Disable Macros / Enable Macros Dialog | Excel Programming |