Archive of Mr Excel Message Board


Back to General Excel archive index
Back to archive home

x1CellTypeConstants value arguement

Posted by Jim on April 13, 2001 8:20 AM
Where can I find the list of values used with x1CellTypeConstants?

Re: x1CellTypeConstants value arguement

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.


Dave

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.