I'm confused.... (PasteSpecial problem)

[mobiius]

I'm using the following code:

Range("M1:N500").Copy
Sheets("Sheet2").Select
Range("A1").End(xlUp).Offset(0, 0).PasteSpecial xlPasteValues
Application.CutCopyMode = False

What this does is grab a column of user names from M on Sheet1 and a list of cooresponding numbers in colum N, also on Sheet 1 and pastes it into Sheet2.

In Cell A1, it has a name as it should, but in B1, it says Counts instead of having the proper value... ?
The rest of the items look ok, it's just that one cell (B1) that isn't right..

Anyone have an idea why this is happening an how to fix it?

 

[doofusboy]

What is in cell N1 of the worksheet you are copying from?

 

[VoG]

I don't understand the Offset(0,0) which does nothing. Maybe

Range("M1:N500").Copy
Sheets("Sheet2").Range("A" & Rows.Count).End(xlUp).Offset(1).PasteSpecial xlPasteValues
Application.CutCopyMode = False

 

[mobiius]

*sigh*...

It's been a very long day.

Sorry about that, small overight on my part.
Thanks for the help guys.