Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Another hyperlink quandry:
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...... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
100% quandry | Excel Discussion (Misc queries) | |||
COUNTIF quandry | Excel Worksheet Functions | |||
Macro Quandry | Excel Discussion (Misc queries) | |||
macro quandry.....?? | Excel Discussion (Misc queries) | |||
SQL Query Quandry | Excel Programming |