| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
changing the name of a hyperlink cell when copied
i have a hyperlink formula that will adjust when i copy it to the cell below
it =hyperlink("#"&cell("address",sheet1!a1),"stk001") stk001 is the name of the hyperlink cell in a1 when i copy this down the page the range adjusts but the cell name doesnt change i need it to change to stk002, stk003, etc. can anybody help thank you brock |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting changing relative when copied to other cell | Excel Worksheet Functions | |||
| Copied hyperlink not working | Excel Worksheet Functions | |||
| Cannot change criteria on copied chart without changing original c | Charts and Charting in Excel | |||
| How to remove Hyperlink without changing cell format? | Excel Worksheet Functions | |||
| Hyperlink changing row | Excel Worksheet Functions | |||
Threaded Mode
