Is there something in the clipboard that can be pasted per the instruction

--
Regards,
Tom Ogilvy


"gj" wrote:

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