Turning off merge-warning
 

Hi
At the VBA end you could try

Application.displayAlerts = False
'do merge code
Application.displayAlerts = True

I'm not sure anything is available at the manual excel end to switch
alerts off.
regards
Paul

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

Turning off merge-warning
 

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

Turning off merge-warning
 

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

Turning off merge-warning
 

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