Maybe

application.displayalerts = false

code to run

application.displayalerts = true


Gord Dibben MS Excel MVP

On Thu, 25 Jun 2009 13:20:02 -0700, iperlovsky
wrote:

I have a histogram macro that I am trying to run, but I receive a prompt that
says something like "output range will overwrite existing data. Press OK to
overwrite data in range..." The window displays the "OK" button, "Cancel",
and "Help". How do I have the macro shut this off or power through this
automatically? PS: The macro runs 20 histograms sequentially.