Check if a cell has a formula.

[diego.gomes]

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.

[Peo Sjoblom]

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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

[CLR]

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
>
>