Hi all,

I've looked around and tried to apply the examples listed here, but I guess
I just don't get it. I have a line of text that I'm parsing for inclusion
into seperate cells in a sheet, one of which should be a hyperlink. When I
try to paste the info into the appropriate cell thusly:

With Worksheets(1)
.Range(.Cells(iRow2, 4)).Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
trim(tText2), TextToDisplay:= _
trim(tText2), NewWindow:=True
End With

I get a 1004 error. I thought the issue might be because the variable,
tText2 is a Variant, so I moved it over to a different variable I defined as
type Hyperlink, but now I get a "Run time error 91: Object variable or With
block variable not set."

Am I supposed to just put the info in, then go back and format it? Sorry I
have to ask.....thanks in advance for any clues......

If you MSGBOX(TRIM(tText2)) what do you see??
--
Gary''s Student - gsnu200759


"pvdalen" wrote:

> Hi all,
>
> I've looked around and tried to apply the examples listed here, but I guess
> I just don't get it. I have a line of text that I'm parsing for inclusion
> into seperate cells in a sheet, one of which should be a hyperlink. When I
> try to paste the info into the appropriate cell thusly:
>
> With Worksheets(1)
> .Range(.Cells(iRow2, 4)).Select
> ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
> trim(tText2), TextToDisplay:= _
> trim(tText2), NewWindow:=True
> End With
>
> I get a 1004 error. I thought the issue might be because the variable,
> tText2 is a Variant, so I moved it over to a different variable I defined as
> type Hyperlink, but now I get a "Run time error 91: Object variable or With
> block variable not set."
>
> Am I supposed to just put the info in, then go back and format it? Sorry I
> have to ask.....thanks in advance for any clues......

Try it without ", NewWindow:= True"
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"pvdalen"
wrote in message
Hi all,
I've looked around and tried to apply the examples listed here, but I guess
I just don't get it. I have a line of text that I'm parsing for inclusion
into seperate cells in a sheet, one of which should be a hyperlink. When I
try to paste the info into the appropriate cell thusly:

With Worksheets(1)
.Range(.Cells(iRow2, 4)).Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
trim(tText2), TextToDisplay:= _
trim(tText2), NewWindow:=True
End With

I get a 1004 error. I thought the issue might be because the variable,
tText2 is a Variant, so I moved it over to a different variable I defined as
type Hyperlink, but now I get a "Run time error 91: Object variable or With
block variable not set."

Am I supposed to just put the info in, then go back and format it? Sorry I
have to ask.....thanks in advance for any clues......

I see the text contained in the variable tText2, within quotes.

"Gary''s Student" wrote:

> If you MSGBOX(TRIM(tText2)) what do you see??
> --
> Gary''s Student - gsnu200759
>
>
> "pvdalen" wrote:
>
> > Hi all,
> >
> > I've looked around and tried to apply the examples listed here, but I guess
> > I just don't get it. I have a line of text that I'm parsing for inclusion
> > into seperate cells in a sheet, one of which should be a hyperlink. When I
> > try to paste the info into the appropriate cell thusly:
> >
> > With Worksheets(1)
> > .Range(.Cells(iRow2, 4)).Select
> > ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
> > trim(tText2), TextToDisplay:= _
> > trim(tText2), NewWindow:=True
> > End With
> >
> > I get a 1004 error. I thought the issue might be because the variable,
> > tText2 is a Variant, so I moved it over to a different variable I defined as
> > type Hyperlink, but now I get a "Run time error 91: Object variable or With
> > block variable not set."
> >
> > Am I supposed to just put the info in, then go back and format it? Sorry I
> > have to ask.....thanks in advance for any clues......

I tried; same thing. Thanks for the thought, though.....

"Jim Cone" wrote:

>
> Try it without ", NewWindow:= True"
> --
> Jim Cone
> San Francisco, USA
> http://www.realezsites.com/bus/primitivesoftware
> (Excel Add-ins / Excel Programming)
>
>
> "pvdalen"
> wrote in message
> Hi all,
> I've looked around and tried to apply the examples listed here, but I guess
> I just don't get it. I have a line of text that I'm parsing for inclusion
> into seperate cells in a sheet, one of which should be a hyperlink. When I
> try to paste the info into the appropriate cell thusly:
>
> With Worksheets(1)
> .Range(.Cells(iRow2, 4)).Select
> ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
> trim(tText2), TextToDisplay:= _
> trim(tText2), NewWindow:=True
> End With
>
> I get a 1004 error. I thought the issue might be because the variable,
> tText2 is a Variant, so I moved it over to a different variable I defined as
> type Hyperlink, but now I get a "Run time error 91: Object variable or With
> block variable not set."
>
> Am I supposed to just put the info in, then go back and format it? Sorry I
> have to ask.....thanks in advance for any clues......
>

The address argument requires a "string".
So change Selection to Selection.Address and omit the newwindow part.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"pvdalen"
wrote in message
I tried; same thing. Thanks for the thought, though.....



"Jim Cone" wrote:
> Try it without ", NewWindow:= True"
> --
> Jim Cone
> San Francisco, USA
> http://www.realezsites.com/bus/primitivesoftware
> (Excel Add-ins / Excel Programming)