Thanks for the response Dave

I have tried this, but unfortunately copying the Hyperlink functio
does not remember the original linked address (ie it doesn't remembe
the worksheet it came from)

I think I will need to write the Hyperlink function programatically..
which I don't know how to do.

Any further help/advice would be appreciated.

Regards
Pete

--
Message posted from http://www.ExcelForum.com