Mangesh,

I have no knowledge in VBA and have never worked with it.
I have checked around in the VB Editor in excel.
I see User Form, Module, ClassModule, Procedure(not highlighted)
How and where do I add your IsNumeric(Range("cellref").Formula)
in VBA? And how could this be used in my spreadsheet?

/Claes

"mangesh_yadav" skrev:


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