ExcelBanter - Return the first visible cell below filter labels

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Return the first visible cell below filter labels (https://www.excelbanter.com/excel-worksheet-functions/71304-return-first-visible-cell-below-filter-labels.html)

REDQUAD

Return the first visible cell below filter labels

Please assist? I'm using lookup in macro running several advance filters on a
sales database.I want a formula/function I can use anywhere in my workbook
always referring to the first visible cell just below my filter labels.

All times are GMT +1. The time now is 10:27 PM.