Macro Hyperlink issues

Hi all,

I'm trying to set up hyperlinks within a cell using a macro. Essentially what I want to do is include a specific cell within the hyperlink. There is a simple example attached.

In words this is what I would like to achieve:

For all Cells in column B:

If Corresponding A on row "Begins with H",

Selection.Hyperlinks(1).Address = _
"\\example\AAA\AAA\AAA\Contents of correspondingcell A.doc"
Selection.Hyperlinks(1).TextToDisplay = "Contents of corresponding cell A"

The same will apply to the remaining columns, only they will have a different hyperlink address. Essentially the hyperlink is formed using the contents of a cell within the workbook.

Any suggestions??

Thanks