Copy worksheet excluding defined name ranges
Hi,
I am really struggling with this and would appreciate some assistance.
What I am trying to do is to copy a worksheet from one workbook to
another. The thing is that both workbooks contain defined names and I
do not want the defined names to follow the sheet when it is copied to
the other workbook. Is there any macro that would either exclude the
defined names in the process of copying the sheet or delete all local
names after the sheet has been copied? Both alternatives would work
for me.
Really hoping to get some help on this!
|