Go to first blank cell after autofilter

[Manish Sharma]

Hi Friends,

I have data table, and I applied autofilter to it with "less than" condition and value as 100 (in this case). Then how can I directly go to cell B17 (First visible cell immediately after the header row after applying filter).

My idea is to exit the procedure if the filtered range does not give any result based on the input data. Like in the above case there are not data in the autofilter table, so the sub procedure should exit it from there.

Please find the sample file attached for your reference.

Thanks & Regards,
Manish

 

[Piyush_Sanghavi]

Hi, code for above is

With Worksheets("ur worksheet name").AutoFilter.Range
  Range("A" & .Offset(1, 0).SpecialCells(xlCellTypeVisible)(1).Row).Select
End With

 

[Manish Sharma]

Hi, code for above is

With Worksheets("ur worksheet name").AutoFilter.Range
Range("A" & .Offset(1, 0).SpecialCells(xlCellTypeVisible)(1).Row).Select

End With

Thanks a lot Piyush, you solved my problem. It is working like a charm.

Regards,
Manish