http://www.mvps.org/dmcritchie/excel...htm#hasformula


you would need VBA if you want to filter for that


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"diego.gomes"
wrote in message
...

Hello,

I would like to know if there is a way to check if a cell has a value
or a formula. I want to filter only the cells with no formulas.

Thankx.


--
diego.gomes
------------------------------------------------------------------------
diego.gomes's Profile:
http://www.excelforum.com/member.php...o&userid=34302
View this thread: http://www.excelforum.com/showthread...hreadid=540698