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 all the precedents of a cell. This can be a multiple selection (a union of Range […]