I have a Customer Version of a workbook which just has the tables used for the drop down lists. We take this (copy all) and paste it into an "internal version" which is the same workbook but with pricing, etc. It never leaves the internal storage.
My question is - when I paste, can I somehow avoid the attached pop up?
I tried paste values only, but it won't allow that due to there being merged cells or different sized cells I guess.
You can only have 1 name for a range in a WB, excel will not let you use the same name for 2 ranges - so no, you cannot avoid that message if you try to use the same name for another range.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks