Hi eemme,
I am having the same issue where I have copied a table from another program and need to simply paste it into a new excel spreadsheet. It works fine if I do it manually by using ctrl+v but I get the error message 'PasteSpecial method of Rang...