Justin
asked on
Excel range I cannot find
Hi Guys, when I go to Name Manager in the Excel attachment, it says there's a range called "Title" linked to "Sheet1". However, I cannot find any tab called "Sheet1" in the attachment. Can anyone help?
London-Liquidity-Report---Week-2---.xlsx
London-Liquidity-Report---Week-2---.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Refer to the attached and click the button on Sheet2 to unhide all the sheets.
London-Liquidity-Report---Week-2---.xlsm
London-Liquidity-Report---Week-2---.xlsm
Perfect Neeraj.
ASKER
superb
Thanks for the feedback JCutcliffe. :)
Thanks Shums. :)
Thanks Shums. :)
Added a VBA in your topic, as this was solved by Neeraj's excellent code.
Name Range Title is linked to Report B2