Paste Values

[Spike]

I found some code on this excellent forum that I've changed as required and it works fine except for the fact that I need to paste values to the destination cells. Code that works is as follows:

Worksheets("Active").Range(Cells(n, 1), Cells(n, 17)).Copy _
Destination:=Worksheets("Ledger").Range("A65536").End(xlUp).Offset(1, 0)

I've done this before but I'm only familiar with the "paste special" vb code when it follows the "Selection" method. ( ie Selection.PasteSpecial etc, etc.)

I'm not at all sure how I can change the code above that follows Destination:= etc ... to paste only values as required for my purposes.

As always any suggestions very much appreciated.


Thanks & Regards,


Spike

 

[Von Pookie]

For paste special, you have to use it as a separate statement. Try:

Worksheets("Active").Range(Cells(n, 1), Cells(n, 17)).Copy

Worksheets("Ledger").Range("A65536").End(xlUp).Offset(1, 0).PasteSpecial xlPasteValues

 

[Spike]

Thanks Von Pookie - works like a charm now.


Cheers ....

Spike