View Single Post
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming
joeu2004[_2_] joeu2004[_2_] is offline
external usenet poster
 
Posts: 829
Default select all cell containing any formula and not text or number

"charles" wrote:
Subject: select all cell containing any formula and not text or number
Using Excel 2003, I need to apply protection/formatting to all cells
with any formula in them and not to cells containing text or numbers.
How can I do that (with or without VBA programming)?


Your subject line suggestions all you need to know is how to select the
cells.

Press ctrl+G or F5 or click on Edit / GoTo, then click on Special to select
the type of formulas that you want to select.