Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
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)? Thanks for any info. |
#2
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
select all cell containing any formula and not text or number
On Mon, 07 Jan 2013 18:51:08 +0000, charles
wrote: 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.) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formula with text and number in cell | Excel Worksheet Functions | |||
How do I select numbers for a formula from a cell including text? | Excel Discussion (Misc queries) | |||
Excel Formula, text & number in cell | Excel Discussion (Misc queries) | |||
number and text in cell for formula | Excel Worksheet Functions | |||
select text in cell based on text from another cell, paste the text at the begining of a thrid cell, etc... | Excel Programming |