Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
supress/answer "name ... already defined" msg when overwriting w/m
I am using a macro to copy|paste "special formulas" over an "identical" copy.
Both worksheets have identical named ranges and the formulas referencing them won't change either. The only thing that is different when running this macro are some of the data values. So, I want to answer yes to the the dialog box (which will pop up several times) within the macro executing the procedure. I know I can displayalerts = false but will that make sure the names used will be the ones in the target sheet? Thanks, owp^3 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I write an excel formula with a text answer ("yes" or "no") | Excel Discussion (Misc queries) | |||
Users overwriting cells with Validation set to "Lists" | Excel Discussion (Misc queries) | |||
Supress "delete sheets" warning | Excel Programming | |||
Supress "delete sheets" warning | Excel Programming |