Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Relative/Current Cell Reference in Hyperlinks
I have a mutli-sheet workbook, each sheet has four standard columns. I
set up a Hyperlink in Column D on my first one so it selecte B1:B25 in the Current Sheet. I want to copy that to the same cell in each sheet, however the link remembers the first sheet since that was the one selected, and I am really looking for Current Sheet. Is there anyway to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Relative cell reference | Excel Discussion (Misc queries) | |||
advanced relative cell reference | Excel Discussion (Misc queries) | |||
Macro to run relative to current selected cell | Excel Discussion (Misc queries) | |||
picture relative to cell reference | Excel Discussion (Misc queries) | |||
Relative Cell Reference | Excel Worksheet Functions |