You can use Excel VBA to quickly find and select all cells that contain a specific type of data, just like using the Go To Specials command.

Specifies the type of cells. Name Value Description xlCellTypeAllFormatConditions -4172 Cells of any format. xlCellTypeAllValidation -4174 Cells having validation criteria. xlCellTypeBlanks 4 […]