I have a cell showing this in the formula bar
='Back Up'!L37
I need to locate /find out where it's reading that value from. But there are no pages called 'back up'. I have checked the hidden pages too.
I notice that when pointing to a page you don't normally see the ' ' punctuation marks. So perhaps It is linked to something different?
Appreciate any help. Thanks.
Last edited by AliGW; 07-10-2019 at 07:58 AM.
Welcome to the forum.
I don't get your comment about the punctuation marks - they are there simply because there is a space in the sheet name.
My best guess without seeing the workbook is that this is a VERY hidden sheet. If so, you'll find it through the VBA editor (Developer ribbon).
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
You'll see the ' marks if the Worksheet has a space in it, which your does.
Have you been in to the VBE to check for Very Hidden Worksheets?
(Press ALT & F11 - All the Worksheets will appear in the Project window on the left hand side)
Thank you for the welcome. It's a busy forum. Didn't expect a reply so quickly. I'll look harder as you suggest. ThanksOriginally Posted by AliGW
Welcome to the forum.
Last edited by AliGW; 07-10-2019 at 07:46 AM.
I did that and see the sheet does exist. It appears as Sheet10 (back up)
But I can't find a method to nav to /open that sheet.
Last edited by AliGW; 07-10-2019 at 07:54 AM.
Once you can see the sheet, click on it in the Project Window with the left mouse button so that it's highlighted.
Underneath the Project Window you'll see the Properties Window (or Press F4 if you can't) - In that window you'll see a 'Visible' property at the bottom, you need to change that by clicking on it and changing the Drop Down list to 'xlSheetVisible'
Or for this time or anytime in the future you can run a quick macro an unhide all sheets that may be hidden.
https://www.ablebits.com/office-addi...-sheets-excel/
Please Login or Register to view this content.
HTH
Regards, Jeff
PaulSP8,
That worked. Thanks so much.
Last edited by jeffreybrown; 07-10-2019 at 07:57 AM. Reason: Removed full quote to clear clutter!
FYI - please select Thread Tools from the menu link above and mark this thread as SOLVED. I'll correct this for you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks