Ryan Sapien wrote:
So do I just have to paste the function into the VBA window and then
add =HyperLinkText(CellName) on my worksheet cell?


Yes
In the VB editor you need to Insert / Module if there are no standard
modules already in your workbook. Then paste the code into that
module.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup