Locate Hidden Cells On Worksheet. You can loop through the worksheets columns and rows checking the worksheetvisible and rangehidden properties. Now you need to access the Excel feature special through one of the following ways.
First select all the cells in the spreadsheet by pressing Ctrl A or clicking in the space between the row and column identifiers. Perhaps a Match instead. Select the worksheet containing the hidden rows and columns that you need to locate then access the Special feature.
Set inserted CellsApplicationWorksheetFunctionMatchSelectedEvent RangeRDS_Event_IDs 0 RangeRDS_Event_IDsColumn.
The assumption as you can see in the screenshot above is that there appears to be a 01 value in either cells B16B17B18. Blank cells have been included in formula but searches for hidden numbers and links in these cells produced nothing. And in that column I have a cell with known static content like abc. Below is some quick and dirty code that will output any hidden elements to the immediate window.