How to Copy the Cell value without its formula

Range(”A1″).Select
Selection.Copy
Range(”C1″).Select
Selection.PasteSpecial Paste:=xlPasteValues

if Cell A1 contains a formula, and you only want to copy its value, use PasteSpecial.