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