select all cell containing any formula and not text or number

C

charles

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

Thanks for any info.
 
J

joeu2004

charles said:
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.
 
C

charles

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

Thanks for any info.

I found that I could do Goto/Special which seems to accomplish the
above. (Discovered this about 12 seconds after hitting the return key to
post the original msg.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top