Check if a cell has a formula.
 

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

Check if a cell has a formula.
 

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

Check if a cell has a formula.
 

F5 Special Formulas OK, will highlight all the cells with formulas.....

Vaya con Dios,
Chuck, CABGx3



"diego.gomes" wrote:


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