from earlier post still trying to figure a hyperlink called from a
command button where i dont have to have cell displaying the hyperlink
url, which is bogus anyway because the hyperlink url is being changed
programatically anyway
the basics of what i'm using this was generously suggested keepIt Cool,
still there keepIt?

Sub ff()
Dim r As Range
Set r = [b3]
r.Hyperlinks.Add r, "", r.Address,"ClickMe"
End Sub

here is what i'm trying

Private Sub CommandButton3_Click()
Dim r As Range
Set r = [o18]
r.Hyperlinks.Add r, "", ivGraphUrl, ""
' ivGraphUrl is a public var that i set

activeworksheet.followhyperlink r

end sub

so the code works in that i get the web page in a new window
but i still get the hyperlink showing in cell 'o18' and not sure why?

and while on the subject.....
no sure about the r.hyperlinks.add syntax

my object browser has this
object.Add(Anchor, Address, SubAddress, ScreenTip, TextToDisplay)

it seems to be saying add a hyperlink to cell 018 twice, once in the
'r.' and secondly the first parameter 'r' ?????
and
i'm really using the sub address instead of the address, they are
interchangeable??

it seems the worksheet has an array of hyperlinks but i'm not adding the
hl to the sheet array directly but to a cell, there is someway to tell
what member of the hl array is for each cell??