I've got a macro which among other things merges cells. When the
macro runs it gives the warning:

"The selection contains multiple data values. Merging into one cell
will keep the upper-left most data only."

I want to automatically prevent this message being displayed as there
are several merges taking place and users will complain about having
to press "OK" every time, is it possible to suppress this type of
message and how can it be done?

Thanks!

Try this at the start of your macro but don't forget to set it to TRUE at the
end of your code.

Application.DisplayAlerts = False

Mike


" wrote:

I've got a macro which among other things merges cells. When the
macro runs it gives the warning:

"The selection contains multiple data values. Merging into one cell
will keep the upper-left most data only."

I want to automatically prevent this message being displayed as there
are several merges taking place and users will complain about having
to press "OK" every time, is it possible to suppress this type of
message and how can it be done?

Thanks!