I would like VBA to insert hyperlink into cell A50 & below for every part
number contained in B1:Z1
..
When the hyperlinks are available in column A, users no longer need to
scroll through B1:Z1 in search of part numbers.

I’ve tried recording macro for hyperlink but can’t seem to understand how to
modify it. My modifications kept returning error, hence, needing your sample.

Thanks a lot

--
Edmund
(Using Excel XP)