Macro & Hyperlink
 

In Column A, from rows 1 to 45, I have part numbers that appear when the part
number is entered elsewhere on the sheet. In Column B, I have Hyperlinks that
take me to the area that part number was entered in. I would like to activate
the Hyperlink adjacent to the first blank cell in Column A. Can this be done
using a macro?

Thanks for your help.

Carl