Give the three areas names. You will then be able to select those names from the name box.
Select a single cell for one of the areas. Type a meaningful name into the Name box 'Name1'. Press enter.
Repeat for the other areas.
Then in the Name box drop down list you will see your names and can select them.
Name Box is where the cell address appears at the top left of the sheet.
Hope this helps
Chris
Click * below if this answer helped
If you are sharing the workbook and you want something that will be easier for everyone, you can insert hyperlinks into 3 cells at the beginning of the worksheet, and maybe at each critical point (see example)
Insert Tab> Hyperlink> "Place in this document"
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
I appreciate all of you that responded - I tried to reply to individual responses twice before I realized it wasn't attaching my response to the actual reply
I appreciate all of your input! Chemist B, I'll remember this for future use if I end up sharing with others. For my purposes at the moment, Chris's suggestion is more aligned with my current needs.
Thanks, again! So glad I found this forum!
smc
Thanks so much, Chris - this is exactly what I needed!
Best regards,
smc
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks