In VBA, you can use IsNumeric(Range("A1").Formula) to find the status of
cell A1 whether it has a formula or a number. The above returns True or
False.

- Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=274418