I have following code in one of the macros.
The purpose is to replace oldname with newname in formulas a range of cells.
These names refer to worksheets in the excel workbook.
The replacement is being done based on user selection via dropdown.
So the summary sheet pulls data from selected worksheet.
It works fine for all names except when a worksheet name contains "&".
For example when a name is "B & G Annex", this code doesn't work.
Can someone suggest a workaround [besides renaming the worksheet as B and G Annex]?HTML Code:
Thanks in advance for help.
Bookmarks