The following code returns all the ranges that have conditional formatting set up. Value is optional and can be one of the following: xlErrors Type is one of the xlCellType constants: xlCellTypeAllFormatConditions This method has two parameters: Type and Value. This enables you to act on cells that meet certain criteria, like this: RangeObject.SpecialCells(Type, Value) To simulate the Go To Special dialog in VBA, use the SpecialCells method. Selecting only visible cells is excellent for grabbing the visible results of AutoFiltered data. In the Excel interface, the Go To Special dialog enables you to select only cells with formulas, only blank cells, or only the visible cells. Figure 3.7 The Go To Special dialog has many incredibly useful selection tools, such as one for selecting only the formulas on a sheet.
