How To Circumvent Overwrite Data Alerts

[carbonboywonder]

Dear all,

I've just written a bit of looping vba script that generates an overwrite alert (i.e. "Output range will overwrite existing data. Press OK to overwrite..."). This is fine and was purposely built into the script, but I want to be able to automatically ignore these alerts and loop through the script unhindered.

Any help would be gratefully appreciated

[shg]

Soooo ... modify the code you wrote before to not give the alerts under whatever circumstance is appropriate.

[carbonboywonder]

Apologies for being a VBA numpty but not sure how to do this. I was kind of hoping that there would be a single line of code that suppressed these messages.

[shg]

Maybe there is, but how would we know without seeing the code you wrote?

[carbonboywonder]

I've sussed this now by clearing the cell contents before the next loop