View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR
 
Posts: n/a
Default 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