CInt doesn't work for range of cells

[sharonng]

I have been trying to convert a selection of string cells to integer by using CInt but a compile error appeared. (Compile error: Identifier expected)
My code is as follows:

'convert new quarter data from string to numeric
Range("c3:f3").Select
Range(Selection, Selection.End(xlDown)).Select
CInt(Selection.Value)

Please help.

 

[Rick Rothstein]

CInt works on a single value only. Does this do what you want...

With Range("C3:F3")
  .NumberFormat = "General"
  .Value = .Value
End With