if you are merging with code

Application.DisplayAlerts = False
' do the merge
Application.DisplayAlerts = True

--
Regards,
Tom Ogilvy


"Konrad Viltersten" wrote:

I use Merge to, well, merge, but every time it's called
i get a warning that i'm about to merge and hence
loose the values in the rest of the merged cells.

How do i make the warning shut up?

--
Vänligen
Konrad
---------------------------------------------------

Sleep - thing used by ineffective people
as a substitute for coffee

Ambition - a poor excuse for not having
enough sence to be lazy
---------------------------------------------------