Try:

With Application
If Not .Iteration Then .Iteration = True
End With



--
Hope that helps.

Vergel Adriano


"VBA_Newbie79" wrote:

Hello Almighty Gurus,
Occasionally I am receiving a Run-time error 1004: method 'iteration' of
object '_application' failed when I use the code Application.Iteration =
True. This time the error seemed to appear due to Iteration already being
turned on in Excel. I adjusted the code to check first to see if Iteration
was true, and if it wasn't, then to turn it on. This resulted in a type
mismatch error.

I am truly perplexed, because VBA help says that the Iteration property is
read/write Boolean.

Any suggestions?