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)