Home |
Search |
Today's Posts |
#1
|
|||
|
|||
variable to refer to "this worksheet"?
Hi,
I have a hyperlink function which when clicked opens another worksheet in the same spreadsheet. At the moment my function is: =HYPERLINK("[SpreadsheetName.xls]NewWorksheetName!Cell", "click here to open new worksheet") can I subsitute the spreadsheet name for something which refers to "this/current spreadsheet". This means if the spreasheet name changes I wont have to change the function. Ive tried the following but neither work: =HYPERLINK("[ThisWorkbook]NewWorksheetName!Cell", "click ...") =HYPERLINK("[ThisWorkbook()]NewWorksheetName!Cell", "click ...") thanks for any help you can give cheers |
#2
|
|||
|
|||
See one more response at your other post.
confused wrote: Hi, I have a hyperlink function which when clicked opens another worksheet in the same spreadsheet. At the moment my function is: =HYPERLINK("[SpreadsheetName.xls]NewWorksheetName!Cell", "click here to open new worksheet") can I subsitute the spreadsheet name for something which refers to "this/current spreadsheet". This means if the spreasheet name changes I wont have to change the function. Ive tried the following but neither work: =HYPERLINK("[ThisWorkbook]NewWorksheetName!Cell", "click ...") =HYPERLINK("[ThisWorkbook()]NewWorksheetName!Cell", "click ...") thanks for any help you can give cheers -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
Refer to Excel Worksheet by its name | Excel Worksheet Functions | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
Formula to refer to other worksheet... | Excel Worksheet Functions |