View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robin Hammond[_2_] Robin Hammond[_2_] is offline
external usenet poster
 
Posts: 575
Default Macro CPU Utilization Issue

More likely, you need a DoEvents statement somewhere within the loop.

Robin Hammond
www.enhanceddatasystems.com

"Zurn" wrote in message
...

You should use

Application.screenupdating = false

Your forms will be shown normally


--
Zurn
------------------------------------------------------------------------
Zurn's Profile:
http://www.excelforum.com/member.php...o&userid=14645
View this thread: http://www.excelforum.com/showthread...hreadid=533594