Paste only values into another spreadsheet after last used rows

[mertian]

Hi guys,

Below is my description of what I need:

Step 1) Copy cells M1:N9 in Sheet 1.
Step 2) Paste the values ONLY in Sheet 2, on column W after last used row.

Worksheets("Sheet 1").Range("M1:N9").Copy

This is what I have now and I'm stuck at pasting.

[MarvinP]

Try:

Dim LastRow as Double
LastRow = Worksheets("Sheet2").cells(Rows.Count,"A").End(xlUp).Row
Worksheets("Sheet 1").Range("M1:N9").Copy Destination:=Worksheets("Sheet2").Cells(LastRow +1, "A")

(not tested)
I just reread the question. Record a macro and see how to paste values only. Then use the "LastRow" idea to select the cell and then Paste Values only.

[jolivanes]

This is what I prefer for these kind of scenarios. No worries copying and pasting.
Change Sheet references as required.

Please Login or Register  to view this content.

Another possibility. Change Sheet references as required.

Please Login or Register  to view this content.