| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert IF formulas to their values
Norman, thanks...................the lessons just keep coming
Greg Norman Jones wrote: Hi Greg, Norman, just one question, what is the 23 in the celltypeformulas and are there other numbers that have a meaning. TIA Each of the SpecialCells method constants have numeric values. These constants can be summed to include multiple options. The value 23 is the result of adding all of the xlCellTypeFormulas contants and is equvalent, in Excel, to checking all of the formula options. --- Regards, Norman |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert formulas to values | Excel Worksheet Functions | |||
| Convert Values to formulas | Excel Worksheet Functions | |||
| Convert formulas to values on save | Excel Programming | |||
| Convert Formulas to Values and Preserve Formatting | Excel Discussion (Misc queries) | |||
| Select range -- convert formulas to values | Excel Programming | |||
Threaded Mode
