Maybe you could modify your =hyperlink() formula:

=HYPERLINK("LotDetail.htm_lot_id(eq)"&$H2&".htm",$ H2)
to
=HYPERLINK("http://LotDetail.htm_lot_id(eq)"&$H2&".htm",$H2)

But I would think you'd need a real URL:

=HYPERLINK("http://www.something.com/LotDetail.htm_lot_id(eq)"&$H2&".htm",$H2)

But I don't know what you're hyperlinking to.



FUBARinSFO wrote:

On Nov 17, 8:17 pm, Dave Peterson wrote:
All thosehyperlinkproperties that you're using in code refer to the
Insert|hyperlinkvariety of hyperlinks (like you've guessed).

Maybe you can parse the formula and pick out the link location from the
formula????

Dave:

1. Yes, they are of the type Insert|Hyperlink. I wasn't aware (until
now) that there was a difference. There is no IsHyperlink property or
method for VBA in Excel, afaik, so I depended on
activecell.hyperlinks.count to identify a hyperlink. For reasons not
clear to me, the formula =hyperlink() didn't result in a hyperlink as
far as VBA was concerned -- yet if the user clicked on it with a
mouse, the link was followed and the local file was opened (an html
web page that had been downloaded).

2. Didn't need to parse the formula, as I already used known values to
create the formula in the first place. I didn't include it in the
example here because I didn't want to clutter up the question with
extraneous detail. Here's a sample, tho:

=HYPERLINK("LotDetail.htm_lot_id(eq)"&$H2&".htm",$ H2)

3. The problem I'm trying to solve is to have a column of links that
the user can hotkey to the target. Literal Insert|Hyperlink works OK
for cell content, but as noted the formula does not.

--

Dave Peterson