hi guys is there a way using vba to copy and paste a hyperlink from a userform to a sheet, without actually losing the the link on the sheet it is copied to, the link works fine on the userform but when i copy data to a sheet it losses the hyperlink functionality.

scouse13