Hyperlink to outside folder

Hello,

I need a little help refining a macro that we are using. We are using this macro to link values in a worksheet to documents with the matching name in an outside folder. This portion is working ok. The problem I'm having comes when theres a blank cell in the worksheet. Then the macro will randomly put some hyper link in the blank cell. How to I tell it to ignore the blank cells?

Please Login or Register  to view this content.

Leith Ross -

Your suggestion worked perfectly. Thank you very much. Your help was usefull indeed.