xlCellTypeFormulas, 16 or 23

[Dennis]

Using 2003 home
2000 work

Searched NG's with Google-search
and 2003 Power Programming
for a list of formula cell types.

In short, what does the 23 and/or 16 mean?

Where is the best place to get documentation
of the possibilities?

TIA Dennis

 

[Jim Rech]

Use the Object Browser to get the value of defined constants. Under
XlCellType xlCellTypeFormula is -4123. 23 and 16 are the sums of
xlCellTypeVisible (12) and xlCellTypeLastCell (11) and xlCellTypeBlanks (4)
respectively.

--
Jim Rech
Excel MVP
| Using 2003 home
| 2000 work
|
| Searched NG's with Google-search
| and 2003 Power Programming
| for a list of formula cell types.
|
| In short, what does the 23 and/or 16 mean?
|
| Where is the best place to get documentation
| of the possibilities?
|
| TIA Dennis
|