syntax Error paste Special Values

[Howardc1001]

i have a macro to copy data from certain sheets and paste these into sheet2 onwards in the destination workbook


the code worked well, but I tried to amend my code so that it pastes the data as values but get a syntax error

Kindly amend my code .Copy after:=ThisWorkbook.Sheets(ThisWorkbook.Sheets.Count).PasteSpecial Paste:=xlPasteValues

Please Login or Register  to view this content.

[romperstomper]

PasteSpecial is a method of a Range object, not a Sheet. What you have copied is a sheet, so you can't pastespecial it anyway.

[Howardc1001]

Thanks for letting me know

I have written code to range value all the sheets after after importing the data