Tom Ogilvy wrote/skrev/kaita/popisal/schreibt :

if you are merging with code

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


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?


Great thanks. I'll try that right away!

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