Copy and paste code pasting won't paste just values

I modified this code from another post, possibly another site and it works somewhat for me. But it pastes everything and I want only the values pasted, and to start on the second line of the target sheet (which it also refuses to do - starts on the first) but it makes no difference. The source sheet has formulas and when it pastes, it wants to calculate values on empty cells and I get a lot of zeros and gobbledy-gook on the target sheet.

What's wrong with this formula?

Please Login or Register  to view this content.

change this line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

OK, so it's now pasting on the correct line (thank you for that), but unfortunately, it's still inserting the zeros and date values (eg.1900-01-00 0:00) that are part of the formulas for the cells, even when there is no data orginally in the cell. I think it's calculating it anyways for some reason when it goes to copy and paste to the target sheet (PassesMaster). I also attached the source sheet (isolated from the original source sheet because of confidential info) and the target sheet to show you how it's presenting. The source sheet was blank when copied to this new worksheet, so you can see it's somewhere in that process that it wants to automatically calculate the values.

Thanks for your help so far. Much appreciated.

The zeroes are appearing because of how the formula is entered. Starting from the last low, row 260 in the "Source sheet", it's returning 0 because B260 is blank, hence returning A261, which is also a blank, but in this case a value of 0 because that's how formulas work. And so the formula works its way up, displaying 0 all the way to the top. You have to either change the formula in row 260 or maybe type an apostrophe ( ' ) in row 261 so the formula returns blank instead of a 0.