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