How define that cell contain date (number) with VBA?

[Useful]

Hi mr excel
in column A contains date and text - in this case i know that it is possible to define this with function - isnumber() but wich VBA function i have to use in that case?
(P.S: in VBA only i know isempty() function)
Thanks!

 

[MrKowz]

The equivalent of isnumber in VBA is IsNumeric()

 

[VoG]

Try IsNumeric

BoolTest = IsNumeric(Range("A1").Value)

 

[Useful]

The equivalent of isnumber in VBA is IsNumeric()

Thank you both (VoG and MrKowz) i'll try this!

 

[shg]

The equivalent of isnumber in VBA is IsNumeric()

Not exactly.

IsNumeric("123") returns True.

VarType(Range("A1").Value2) = vbDouble will tell you if a cell contains a number.

VarType(Range("A1").Value) = vbDate will tell you if it contains a number formatted as a date.

 

[Useful]

The equivalent of isnumber in VBA is IsNumeric()

Not exactly.

IsNumeric("123") returns True.

VarType(Range("A1").Value2) = vbDouble will tell you if a cell contains a number.

VarType(Range("A1").Value) = vbDate will tell you if it contains a number formatted as a date.

Hi dear friend SHG of course thanks for your advice that is good idea too
also i can use this code that defines is cell contain date or number returns true

If isnumeric(Range("A5").DataSeries) Then

Shg i really appreciate your advice thanks for everybody