Iteration Error

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?
 
V

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top