Archive of Mr Excel Message Board
Back to General Excel archive index
Back to archive home
x1CellTypeConstants value arguementPosted by Jim on April 13, 2001 8:20 AM
Where can I find the list of values used with x1CellTypeConstants?
Re: x1CellTypeConstants value arguementPosted by Dave Hawley on April 13, 2001 4:59 PM
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
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.