Istext function

[ExcelMonkey]

Is there a way in VBA to tell whether a cell has text in it? I kno
that there is a hasformual property and ther is an isnumeric functio
but I cannot find anything like istext.

Thank

 

[Frank Kabel]

Hi
you may use:
application.WorksheetFunction.istext

 

[Tom Ogilvy]

? vartype(activeCell) = vbString
True