MS EXCEL - To supress warning messages created by Anlysis ToolPak


Niyaz Rasheed


I have been creating a MS ACESS Application, whose final output will be an
excel sheet having a histogram in it ( created using analysis toolPak add ins

I have suppressed all the warning messages created by excel using
Application.DisplayAlerts = False

But I am unable to suppress the messages created by analysis toolPak Add
INS macro for “Histogramâ€

Do you have any solution for this? It will be of great help.

Application.DisplayAlerts = False
"ATPVBAEN.XLA!Histogram"ActiveSheet.Range("$B$3:$B$10002") _
, ActiveSheet.Range("$E$3:$F$104"), , False, False, True, False
Application.DisplayAlerts = True

The messages that I got were

1) Histogram – Output range will overwrite the existing data. Press OK to
overwrite data in range
2) Histogram – some data will be hidden by embedded chart(s)

Thanks & Regards,
Niyaz .R



Andy Pope

Clear the range ActiveSheet.Range("$E$3:$F$104")
before executing the Application.Run command.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question