T
themiz
Hi there, I have a worksheet with vlookups referencing other tabs in th
workbook. My plan is to replace a few of those tabs, so I have create
new worksheets and tried to just change the name of the new tab to matc
the old one (so the vlookups will still work).
However I get an error stating "Cannot rename a sheet to the same nam
as another sheet, referenced object library or a workbook referenced b
Visual Basic". I have changed the name of the original tab but th
vlookups just change to the new tab name
Is there any way to work around this? Thanks
xpost-http://www.mrexcel.com/forum/excel-questions/684441-nanaming-tabs-fit-formulas.html#post338773
workbook. My plan is to replace a few of those tabs, so I have create
new worksheets and tried to just change the name of the new tab to matc
the old one (so the vlookups will still work).
However I get an error stating "Cannot rename a sheet to the same nam
as another sheet, referenced object library or a workbook referenced b
Visual Basic". I have changed the name of the original tab but th
vlookups just change to the new tab name
Is there any way to work around this? Thanks
xpost-http://www.mrexcel.com/forum/excel-questions/684441-nanaming-tabs-fit-formulas.html#post338773