| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
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 --------------------------------------------------- |
|
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
|
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 --------------------------------------------------- |
|
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
|
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 --------------------------------------------------- |
|
#4
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
|
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 --------------------------------------------------- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Office 2003 merge questions | Excel Worksheet Functions | |||
| Difficult for me, probably basic to you | Excel Worksheet Functions | |||
| Turning of merge warning message | Excel Discussion (Misc queries) | |||
| Turning off merge message | Excel Discussion (Misc queries) | |||
| Word found no merge fields in your main document. | Excel Discussion (Misc queries) | |||
Linear Mode
