what is wrong with my code? It works when I leave it like this:

Sheets(“Strategie”).Range(“C8”).Copy Sheets(“Úkoly”).Range(“H” & Rows.count).End(xlUp).Offset(1)

When I add PasteSpecial it stops working. I need to paste only value in the target cell.

Sheets(“Strategie”).Range(“C8”).Copy Sheets(“Úkoly”).Range(“H” & Rows.count).End(xlUp).Offset(1).PasteSpecial xlPasteValues

I tried to search it on forums.