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

--
ExcelMonke
-----------------------------------------------------------------------
ExcelMonkey's Profile: http://www.excelforum.com/member.php...nfo&userid=522
View this thread: http://www.excelforum.com/showthread.php?threadid=26906

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

? vartype(activeCell) = vbString
True

--
Regards,
Tom Ogilvy

"ExcelMonkey" wrote in message
...

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


--
ExcelMonkey
------------------------------------------------------------------------
ExcelMonkey's Profile:
http://www.excelforum.com/member.php...fo&userid=5221
View this thread: http://www.excelforum.com/showthread...hreadid=269061