Unwanted warning

I use the procedure below to fill tables with values rather than formulae.

Please Login or Register  to view this content.

Usually this works.
However I now have a situation where the following warning comes up on each iteration

"Do you want to replace the contents of the destination cells." Yes/No

What circumstances must I have created to cause this warning to appear, when usually it does not, and how can I stop it?

John

Does using Application.DisplayAlerts = False at the start of your code and switching it back to True at the end work?

BSB

Or:

Please Login or Register  to view this content.

BSB

Badlyspelledbouy,
Thanks for your interest. Application.DisplayAlerts = False does stop the message from appearing. I am curious as to why, after years of using that little procedure without the message, should it now start appearing. In trying to discover what was going on I found that there are some circumstances where I can create an unending loop, would this cause the message?
John

Do you have any event code that this might be triggering?

Originally Posted by j_Southern

In trying to discover what was going on I found that there are some circumstances where I can create an unending loop, would this cause the message?

Not easy to diagnose without seeing the workbook to ascertain exactly what's happening.

BSB

If it is not immediately obvious it is not worth anybody's time digging deep. But thanks for your interest