Pesky dialogue box keeps VBA code from running smooth...

First question here, so appologies for any newb mistakes.

Problem: the VBA macro below works great to get a regression started, but the standard function dialogue box asking it it's ok to over-write existing data keeps the code from running smooth. Appreciate any suggestions to remove the pesky dialogue box.

Please Login or Register  to view this content.

Running VBA code in Excel 2007.

You could try:

Please Login or Register  to view this content.

Did you try disabling DisplayAlerts in your macro..

Please Login or Register  to view this content.

This usually stops the application from prompting user for alerts.

Thank you yudlugar and codeslizer for the quick and detailed suggestion!

Well, tried the suggestion but still get the dialogue box below...

Dialogue.jpg

???

I guess the xlam add-in ignores the display alerts setting. Why don't you just clear the cells where you are putting the regression analysis and then the dialogue box won't appear?

e.g.

Please Login or Register  to view this content.

Originally Posted by yudlugar

I guess the xlam add-in ignores the display alerts setting. Why don't you just clear the cells where you are putting the regression analysis and then the dialogue box won't appear?

e.g.

Please Login or Register  to view this content.

Winner, winner...

Simple and elegant solution that works. Thanks!