Iteration Error

[VBA_Newbie79]

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?

 

[Vergel Adriano]

Try:

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

 

[VBA_Newbie79]

Vergel,
Application.Iteration=True seems to be working again. I will definitely
keep your suggestion in mind though, because it is probably going to happen
again. Thanks!