Hi Gary's Student:

Thanks for the UDF. But as I noted in my reply just now above, I"m
not trying to extract the address, since I've formed it with formula
elements in other cells/columns on the sheet. I'm trying to follow the
link using:

ThisWorkbook.FollowHyperlink myLink

Since the forumula-based link =HYPERLINK() isn't recognized as a
hyperlink, the .FollowHyperlink method fails. I'm at a bit of a loss
at the moment in figuring out what property or method to invoke to
convert the formula into a "hyperlink" as recognized when a Insert |
Hyperlink literal creation method is used.

What I did yesterday to get around this problem was to insert another
colum which contains now just the hyperlink string itself, rather than
the formula. This works for now, but it leaves me with the bad
feeling about the =HYPERLINK() formula itself.

-- Roy