Hi again Jeff,
Just writing again to add some clarification to Marty and my solutions.
The 'TYPE MISMATCH' you were getting was with the first parameter. Excel wants to receive an object, and you were sending in a string ('a1')
You needed to send either:
xl.activesheet.cells(1,1)
or
xl.selection
or
xl.activesheet.range("a1")
or something that refers to the area that you're applying the hyperlink to.
Hope this helps shed some light on the fun world of XL automation :^)
Paul A. Busbey
Victoria Insurance