MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Using ALL my resources!


Posted by doug on February 13, 2001 2:04 PM

Is there anyway i can make my macro use less resources?... When i say this i mean in terms of making the macro wait for the resources to come back up then continues? Or something to this effect? Thanks!


Posted by Faster on February 14, 2001 5:25 PM

'this may help
'if you are not using it already
'make it the first line in your code

Application.ScreenUpdating = False

Posted by doug on February 19, 2001 12:48 PM

I have added this to my macro and it reduces resource use tremendously, however my graphs are not in the correct place when this line is added. Anyone know a way around this or a fix?