Excel Macro

[sabs2014]

I am trying to write a macro to Copy Paste Special Value from one cell to another. I've written the following but its not working. Can someone help please:

Sub PasteSpecialValue()
Range("C35").Select
Selection.Copy
Range("B35").Select
ActiveSheet.PasteSpecial
End Sub

 

[oldbrewer]

switch on macro record and do it - then look at the code

 

[mumps]

Try:

Sub PasteSpecialValue()
    Range("C35").Copy
    Range("B35").PasteSpecial xlPasteValues
    Application.CutCopyMode = False
End Sub

 

[sabs2014]

Works!!!! Thanks a lot!!!!

 

[mumps]

My pleasure.