Hi kvanhal,
'Failed to paste from clipboard: PasteSpecial method of Range class failed' occurs because either the object is empty or it has not target.
With ""paste"" you throw your data into a workbook, rather worksheet with selected cell.
Instead...