Copy Paste Values only

[vestax22]

Hi, I have a sub in my excel application that copys a range inside a worksheet to another range insode the same worksheet. Heres my code :

With Worksheets("Billing&quot

.Range("K68:K76&quot.Select
Selection.Copy
.Range("M68&quot.Select
Selection.PasteSpecial Paste:=xlValues

End With

This code doesn't seem to work. No errors though and when I execute the macro by itself it works. It seem not to work when executed inside my code and there doesn't seem to be anything that could cause a conflict.

Any ideas???

Thx

 

[Bowers74]

This should put you on the right track:

Sub PasteSpecial()
Range("A1").Copy
Range("B1").PasteSpecial Paste:=xlPasteValues
End Sub

Peace!

Mike

Never say Never!!!
Nothing is impossible!!!