Sometimes it works and sometimes it doesn't

ActiveWorkbook.FollowHyperlink Address: .................
ActiveSheet.PasteSpecial Format:="Text",Link:=False DisplayAsIcon:=
False

GET: Rin-time error 1004
PasteSpecial method of Worksheet class failed

Thanks,
GJ