Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I built a hyperlink in a cell that works fine when I click on the cell that
looks like this =HYPERLINK(CONCATENATE("http://",'Toolkit Setup'!$A$16,"/",'Toolkit Setup'!$M$12),"Agent "&'Toolkit Setup'!$M$12&" WEB Site") In a macro I am trying to execute this but it fails with a subscript out of range on the Selection.Hyperlinks(1).Follow ' If no Agent web site then Alert and Exit If [A17] < "" Then Range("A17").Select Selection.Hyperlinks(1).Follow GoTo Exit_1 Else MsgBox "Agent WEB Site Missing From Toolkit Setup", , "Agent WEB Site Access" End If GoTo Exit_1 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
formula construction | New Users to Excel | |||
Array Construction | Excel Discussion (Misc queries) | |||
Construction Templates | Excel Discussion (Misc queries) | |||
formula construction w/ vba | Excel Programming | |||
formula construction | Excel Programming |