MrExcel Publishing
Your One Stop for Excel Tips & Solutions

x1CellTypeConstants value arguement

Posted by Jim on April 13, 2001 8:20 AM

Where can I find the list of values used with x1CellTypeConstants?

Posted by Dave Hawley on April 13, 2001 4:59 PM

Hi Jim

They can be found under the help in the VBE. They are part of SpecialCells.

Value Optional Variant. If Type is either xlCellTypeConstants or xlCellTypeFormulas, this argument is used to determine which types of cells to include in the result. These values can be added together to return more than one type. The default is to select all constants or formulas, no matter what the type. Can be one of the following XlSpecialCellsValue constants: xlErrors, xlLogical, xlNumbers, or xlTextValues.

Type "SpecialCells Method" in the help for the whole thing.


OzGrid Business Applications