adding hyperlinks
 

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

adding hyperlinks
 

Just use Selection for the Anchor, like this:

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

Hope this helps,

Hutch

"greg" wrote:

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

adding hyperlinks
 

ok, thanks

"Tom Hutchins" wrote in message
...
Just use Selection for the Anchor, like this:

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

Hope this helps,

Hutch

"greg" wrote:

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