Getting VBA to answer Name Conflict dialog box automatically with Yes
Posted by Mick on February 13, 2002 12:24 PM
I have written a macro to copy all the data cells from one file to another. I have several named ranges, which are identical on both files, but I use the named ranges in my cell Validation. When I copy the cells over, if there is a validation which uses the named range, Excel pops up with a dialog box asking if I want to use the name on the destination sheet or not. The default is Yes but I can't figure out how to write a code that would always simulate Yes whenever this dialog box comes up. Any suggestions?