VBA help - values not formula wanted

[Myproblem]

I wrote this code:

Sub eeeee()
Range("c1:c12").Select
Selection.Copy
Range("a1").Select
ActiveSheet.Paste
Range("h1:h12").Select
Selection.Copy
Range("f1").Select
ActiveSheet.Paste
End Sub

but it give me formula not values, what is wrong?
any tips

 

[VoG]

Try

Sub eeeee()
Range("C1:C12").Copy
Range("A1").PasteSpecial Paste:=xlPasteValues
Range("H1:H12").Copy
Range("F1").PasteSpecial Paste:=xlPasteValues
End Sub

 

[MrKowz]

Try:

Sub eeeee()
Range("c1:c12").Copy
Range("a1").PasteSpecial Paste:=xlPasteValues
Range("h1:h12").Copy
Range("f1").PasteSpecial Paste:=xlPasteValues
End Sub

 

[mikerickson]

You are using copy and paste. If the source cells (C1:C12 H1:H12) contains formulas then pasting will put them in A and F.
You could try

Sub eeeef()
    Range("A1:A12").Value = Range("C1:C12").Value
    Range("F1:F12").Value = Range("H1:H12").Value
End Sub

 

[Myproblem]

thx guys, it works in any of yours ways