Select Cells With Formulas

This can be done with the Go To dialog box also (Push F5, then Special)

Sub SelectFormulaCells()
 Selection.SpecialCells(xlCellTypeFormulas, 23).Select
End Sub

Tip 1: Look at "SpecialCells" in the VBE Help files so see what other kinds of Special Cells are available (blanks, comments etc) "Constants" is another way of saying "Values"

Tip 2: If only one cell is selected, all cells in the active sheet will be searched. If two or more cells are selected, only the selection will be searched.

© Copyright All Rights Reserved.