Not a code man, just trying to find some help
- I have a worksheet named "Margin" where a user enters several names in cells B11 through B24 for different projects.
- The following worksheets have a cell (A4:E4 Merged) that calculates its name from the appropriate cell in "Margin".
(=Margin!B11 for example)- I would then like to have each worksheet name itself based on that value
- If a relevant value is blank (ie no project name), the worksheet should hide itself.
This is my code (borrowed from several sources) but it is not functioning. Help would be appreciated.
- Possible issues... IsEmpty is not the correct command since the fomula returns "0" for a blank cell?
- The macro does not seem to be running at all...even just a name change is not renaming the tab?
Thanks for any pointers you have!
Added code tags...sorry about that![]()
Please Login or Register to view this content.
Bookmarks