Hi Cory,

Thanks for the reply, I'm sorry I should have been clearer as to what
I'm trying to achieve.

Basically I want to have this macro linked to a button. The user could
then select a cell where they'd like a hyperlink, click the button (and
be prompted for the URL etc), and then have the link generated into the
cell they initally selected.

The problems with my macro above a

1) The 'final' cell is static... I need to add in something that takes
the user's selected cell, and uses that cell for the final output
2) The formula is referencing cells Z9 & Z10. So next time someone
updates these cells, the historic hyperlinks will change & all be the
same.

I was trying to do a macro (please don't laugh, I'm fairly new to this)
which selected the text from the user-input cells, and then copied &
pasted them into a Hyperlink formula. This didn't work for some reason,
possibly because I had to break out from the formula to select & copy
the required text.

any ideas gratefully received :)