|Your code looks right, but I can't test it since I don't have Excel.|
One way to check and see it the problem is the Copy or the Paste is to single step through the code using F8.
Put your cursor anywhere in the code and pres F8. Each time you press F8 it will execute one line. After it executes Sheets(1).Range("N20").Copy click anywhere in your spreadsheet and manually do a Paste (or PasteSpecial) if it Pastes N20, then you'll know that the code copied it.
Then go back into the VBA editor and hit F8 to execute the PasteSpecial line.
Let us know what you find.