supress/answer "name ... already defined" msg when overwriting w/m

  • Thread starter Thread starter owp^3
  • Start date Start date
O

owp^3

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
 
Yes. If you temporarily disable alerts, pasted formulas, with similar names
in each workbook, will assume the name in the destination (target) workbook,
ie as if you had answered yes. Of course the similar names might refer to
very different things.

Regards,
Peter T
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compile Error:Variable not defined 4
Losing Named Range Definitions 10
XL03: Avoid "workbook contains links" msg when opening 5
Goto Worksheet with Defined Range Name 12
Problem with VBA Macro Consolidating data 3
One final question 1
Macro defining dynamic named ranges 2
Don't want to hard-code file name in macro 3

Back
Top