Sub demo()
With Sheet1.UsedRange
.Value = .Value
End With
a = Range([b2], [b2].End(4))
For i = 1 To UBound(a)
a(i, 1) = CDate(a(i, 1))
Next
[b2].Resize(UBound(a)) = a
End Sub
Sub demo()
With Sheet1.UsedRange
.Value = .Value
End With
a = Range([b2], [b2].End(4))
For i = 1 To UBound(a)
a(i, 1) = CDate(a(i, 1))
Next
[b2].Resize(UBound(a)) = a
End Sub