Macro to cut and paste but recognise a hyperlink

[MagicMan]

Hi All,

With a Macro I have the following code:

Please Login or Register  to view this content.

However, sometimes, but not always, the data being cut and paste may be a hyperlink to a website. Is there any way I can modify this code so it looks to identify whether or not it's a hyperlink and if it is retain the hyperlink properties in the sheet it is pasted to?

Alternatively, is there something I can do after pasting that would 'activate' the hyperlink? I tried recording the macro using F2 and enter, but all that did was change the posting to specific text.

Many thanks

Terry