Thread
:
Speed up macro
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
Speed up macro
It may help if we could SEE your code.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"TGalin" wrote in message
...
I have 3 worksheets. Each worksheet has 44,000 cells with formulas in
them.
Altogether that comes out to 132,000 cells with formulas.
I added a long macro to the workbook which works mostly with another
worksheet. When I run the macro it takes a ridiculously long time to
complete the steps. The reason it takes so long is because of the 132,000
cells with formulas. When I remove those 3 worksheets, its works fine.
Is there a way I can speed up the macro without getting rid of the 3
worksheets I mentioned or purchasing extra memory for my computer?
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett