Tim,

Just to let you know it worked just fine with 2002.


"Tim Williams" wrote:

Yep - always happens when I don't test before posting..

Good luck with the 2002..

Tim


"Darrell Wesley" wrote in message
...
Changing this to
selection.formula = "=HYPERLINK(""" & sURL & """,""" & sText & """)"
allows this formula to be inserted and it at least works on my Excel2000.
Will be trying it soon on a Excel2002 version.