Iteration Error

  • Thread starter Thread starter VBA_Newbie79
  • Start date Start date
V

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,
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!
 
Back
Top