Home ยป Range.DirectPrecedents property
Learn
Go To Special with VBA
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.
Docs
Range.DirectPrecedents property
Returns a Range object that represents the range containing all the direct precedents of a cell. This can be a multiple selection […]