| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Using a formula in a Hyperlink Cell reference
I have a workbook with approx 60 worksheets in it. I have set up hyperlinks
on the 1st sheet to take me directly to the worksheet I want to see. Is there any way of using a function in the Hyperlink cell reference, so the link will automatically position me at the right cell on the target sheet? I thought I could use the COUNTA function to determine the first non-blank cell, but the hyperlink doesn't seem to like it. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| cell reference in a formula is called | Excel Discussion (Misc queries) | |||
| can't move a named cell without breaking a hyperlink to that cell | Links and Linking in Excel | |||
| how to cell reference a Chart title | Charts and Charting in Excel | |||
| Is there a way to transfer a style by cell referrence in a formula | Excel Discussion (Misc queries) | |||
Threaded Mode
