View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Souris Souris is offline
external usenet poster
 
Posts: 107
Default add comment in the loop

I had to add wait to fill the spreadsheet.
I tried to use screen updating, but it is the same,

Thanks again for helping,

"Kalpesh" wrote:

Hi,

How about adding Application.ScreenUpdating = false before the loop.
And, set it to true once the loop is over.

Does that work?

Kalpesh