maybe you used

set r = activecell.Range

application.IsText(r)

or
if vartype(r) = vbString

or
typename(r.value) = "String"

there is an Isnumeric, but that checks if the variable can be evaluated or
treated as a number - it could be stored as a string.

--
Regards,
Tom Ogilvy


"Ian Parker" wrote:

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.