Select first cell after filter in Column AI

[cmb80]

Hi there, I now have a macro that filters info by date, what I want to do is then select the first cell in Column AI after the filter has occurred.

The row number will be changeable, and sometimes no cells will be shown after a filter so need to account for that.

Thanks very much in advance

[Solus Rankin]

Perhaps?

Please Login or Register  to view this content.

[cmb80]

Thanks, but that just selects cell AI2 (so isn't finding the first filtered row, just the first row below the headers)

[Solus Rankin]

What do you mean by first filtered row?

Perhaps you should include an example workbook illustrating what you're trying to achieve.

[cmb80]

After I filter by date, the first row displayed