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

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
>
>
>

ok, thanks

"Tom Hutchins" <(E-Mail Removed)> wrote in message
news:812348AB-C8A1-41C4-B3CA-(E-Mail Removed)...
> 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
> >
> >
> >