I've got a VBA macro in Excel 2019 to allow me to paste a hypalink into the active cell. However, I'm getting the following error:
"1004 application defined or object defined error"

This is the code I'm using. Any help would be appreciated. The variable CurrentCellText holds the website URL which is saved into it from the clipboard:

Please Login or Register  to view this content.
Thank you,