Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to write an adjustable hyperlink to named cells
im trying to write a series of hyperlinks to named cells in the same workbook
for example hyperlink stk001 on sheet1 will link to the cell with text stk001 in sheet2 i need to do this for stk001 - stk 999 so id like to be able to copy it down the spreadsheet and i want the hyperlinks to adjust if i add rows in to sheet2 which is why i want them linked to a named cell thank you for your time and assistance barry spokane, wa |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to write an adjustable hyperlink to named cells
You might like this better. Almost no overhead. Right click sheet tabview
codecopy/paste thismodify to suitSAVE workbook. Now type in the text to goto on the other sheet and you will be taken there to the cell containing the text you typed in cell d2 on the original sheet. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address < "$D$2" Then Exit Sub On Error GoTo notthere Application.Goto Sheets("sheet3").Columns("c").Find(Target, lookat:=xlWhole) Exit Sub notthe MsgBox "Not there" End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "BROCK8292" wrote in message ... im trying to write a series of hyperlinks to named cells in the same workbook for example hyperlink stk001 on sheet1 will link to the cell with text stk001 in sheet2 i need to do this for stk001 - stk 999 so id like to be able to copy it down the spreadsheet and i want the hyperlinks to adjust if i add rows in to sheet2 which is why i want them linked to a named cell thank you for your time and assistance barry spokane, wa |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to write a macro that copies adjustable hyperlinks into a sprd | Excel Discussion (Misc queries) | |||
Activate Hyperlink in Named Range | Excel Worksheet Functions | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
automatically adjustable cells | Excel Discussion (Misc queries) | |||
How to open a spreadsheet on a named sheet from a hyperlink? | Links and Linking in Excel |