Ian,

Perhaps?

If Application.IsText(yourValue) Then
MsgBox "That was a string"
Else
MsgBox "That wasn't a string"
End If

HTH,
Bernie
MS Excel MVP


"Ian Parker" wrote in message
.com...
I have used the VBA function IsString in the past and I do not remember any problems. I have
upgraded to Office 2003 and suddenly I can not test if a member of a record set is a string. Please
tell me if there is a new or another old way that still works.

There seems to be a IsNum but no IsString.