Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Sep 2001
    Posts
    32
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Special Cell List (Excel 97)

    Hello,

    I was wondering if anyone had a list of the special cell types around.

    e.g. SpecialCells(xlCellTypeBlanks)

    Thanks!

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Special Cell List (Excel 97)

    From Help:

    Syntax
    expression.SpecialCells(Type, Value)
    expression Required. An expression that returns a Range object.

    Type Required Long. The cells to include. Can be one of the following XlCellType constants.

    Constant Description
    xlCellTypeNotes Cells containing notes
    xlCellTypeConstants Cells containing constants
    xlCellTypeFormulas Cells containing formulas
    xlCellTypeBlanks Empty cells
    xlCellTypeLastCell The last cell in the used range
    xlCellTypeVisible All visible cells
    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 XlSpecialCellsValues constants: xlErrors, xlLogical, xlNumbers, xlTextValues, xlAllFormatConditions, or xlSameFormatConditions.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    Lounger
    Join Date
    Sep 2001
    Posts
    32
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Special Cell List (Excel 97)

    Thank-you very much!

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Special Cell List (Excel 97)

    The following example will select all cells in the active worksheet that contain a formula which returns an error, such as #N/A, #DIV0! etc.

    Cells.SpecialCells(xlFormulas, xlErrors).Select

    Andrew C

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •