View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
[email protected] paul.robinson@it-tallaght.ie is offline
external usenet poster
 
Posts: 789
Default 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
---------------------------------------------------