adding hyperlinks

[greg]

Hello,
I am in excel. adding a hyperlink to a range.
So
Range.Hyperlinks.Add
Now it seems to want 2 items
Anchor As Object, Address As String
What is this anchor?
I am already adding it to a range object.
from the range object I already have,
can I create this anchor object? how can I do that?
thanks

 

[Guest]

Just use Selection for the Anchor, like this:

ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= etc.

Hope this helps,

Hutch

 

[greg]

ok, thanks

Just use Selection for the Anchor, like this:

ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= etc.

Hope this helps,

Hutch