I have a some pivot tables in a sheet, with lots of blank rows to separate them so that if one suddenly gets a lot of values it won’t overwrite the pivot table underneath. But to avoid the user having to scroll down quite far to see the other pivot table, I have a formula in column A which checks if anything is populated on each row and have then written some VBA to hide the rows that the formula has identified is empty.

I am new to VBA and I have been struggling to build a macro that accurately identifies cells in the selected range that are referenced by formulas in other sheets and selects only those cells that fulfill that criteria.