I've got code to rename a sheet based on cell contents:
And it works beautifully 'most' of the time, when acting directly on the sheet, like this:![]()
Please Login or Register to view this content.
It doesn't work, however, when used during formula creation... see code below. I get a couple of "Update Values: sheetName1" during execution. Doesn't keep the macro from finishing, but those formulae don't work properly.![]()
Please Login or Register to view this content.
Any help and/or direction is greatly appreciated!![]()
Please Login or Register to view this content.
Bookmarks