Filter Macro Help 1

[Sridharan]

Hi,

Does anyone have a macro which will go to the first cell of a row after applying an autofilter in an excel sheet dynamically i.e. after applying the filter and running the macro it should go to the first row of the filtered value. Sometime it can be A2 or sometime it can be A10 depending on the filter condition i give.

Any ideas.

Many A Thanks

Sri

 

[GlennUK]

How about something really simple ...

Sub GoToFirstRow()
Range("A1&quot.Select
SendKeys ("{DOWN}&quot
End Sub

not sophiticated, but will do the trick.

Glenn.

 

[Sridharan]

Glenn,

Thanks a lot.

Sri