Add Hyperlink

[Edmund]

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)

[Leith Ross]

Hello Edmund,

Here is the macro to "bookmark" your parts on the worksheet. Change the Worksheet name (its commented in the code) to whatever the name of your worksheet is. The example assumes Sheet1.

Please Login or Register  to view this content.

Sincerely,
Leith Ross