Finding Formulas in Range
There is an Excel file that teaches how to perform the Finding Formulas in Range operation.
Excel Professional Finding Formulas in Range
This workbook demonstrates finding formulas in range using VBA macros on a 16-row data layout.
Hope it is useful.