Copy Sheets From Another Workbook Without Named Ranges

[Dikolis]

Hi all,

I'm new to this forum and thought I'd give a shot at my problem. I have VBA code that copies over several sheets from a workbook, but I'd rather not have all the named ranges come through.

Whenever I run the macro it gives me this notice: "A formula or sheet you want to move or copy contains the name 'rngRegion2', which already exists on the destination worksheet..." The destination sheet doesn't originally have this range already, it runs into problems because the sheets I'm copying have rngRegion2 defined on different sheets. I'd like to try and avoid this problem all together by not copying named ranges if possible.

If thats not a viable option, is there code that I can use to tell it to automatically select "Yes - To use the name as defined in the destination sheet" as opposed to prompting the user to select yes/no?


Thanks in advance!

[JBeaucaire]

This can be used to suppress messages and always take the default answer:

Please Login or Register  to view this content.

[JBeaucaire]

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].


(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)