| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a HYPERLINK with a macro?
Sheets("Index").Select
Range("A5").Select Dim mycel As String mycel = (ActiveCell.Value) ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _ mycel & "!A1:B1" Using info originally obtained from Don...Thanks Don! --- Message posted from http://www.ExcelForum.com/ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to create an automatic hyperlink | Excel Discussion (Misc queries) | |||
| How do I create a macro to remove path from hyperlink "address"? | Excel Discussion (Misc queries) | |||
| Create a Hyperlink as part of a macro | New Users to Excel | |||
| How do I create a hyperlink to a cell with the hyperlink function | Excel Worksheet Functions | |||
| Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) | |||
![bobgerman[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
