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.

Returns a Range object that represents the range containing all the direct dependents of a cell. This can be a multiple selection […]