| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Update a hyperlink in excel spreadsheet
I have a number in cell A1 that counts the rows in use, say 11000.
I have a hyperlink that I use to go to the bottom of the spreasheet in cell A2 to reference row 11000. However, every time I paste data cell A1 changes to read 12000. In order to reference row 12000, I must change the hyperlink info manually. Is there a simple code to automatically change the hyperlink to reference row 12000? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel spreadsheet will not update | Excel Worksheet Functions | |||
| sort excel spreadsheet with hyperlink | Excel Discussion (Misc queries) | |||
| How to hyperlink pdf files in excel spreadsheet | Excel Discussion (Misc queries) | |||
| How do i update hyperlink in excel spread sheet automatically. | Excel Discussion (Misc queries) | |||
| Excel email address hyperlink does not update | Excel Discussion (Misc queries) | |||
![rhhince[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
