For a more general solution, there is always "Tools/Options.../Edit", "Alert
before overwriting cells" (uncheck the box).

Eric

"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.