This can be done with the Go To dialog box also (Push F5, then Special)
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.