Hi
you may use:
application.WorksheetFunction.istext


--
Regards
Frank Kabel
Frankfurt, Germany


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

Thanks