In my current workbook when I copies a sheet the cell names are missing. I've never had this problem. When I create a cell name they show up and can be used on all sheet. Not this time. How can I fix it so cell names show up on all sheets?
In my current workbook when I copies a sheet the cell names are missing. I've never had this problem. When I create a cell name they show up and can be used on all sheet. Not this time. How can I fix it so cell names show up on all sheets?
This works for me (2016)
Right click on sheet tab \ click "move or copy" \ click "create a copy" ok
The custom name is in both worksheets
CustomNames.jpg
Last edited by kev_; 04-11-2018 at 01:51 PM.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks