MrExcel Publishing
Your One Stop for Excel Tips & Solutions

AutoFilter Question


Posted by Jonathan on June 21, 2001 8:37 AM

I have built code that automatically opens an autofilter and selects the criteria that I want. I have the code select the cell with the column header and then launch the autofilter. What I am having an issue with is this: I need to tell it to step down to the cell below. Example: I select J12 and lauch the autofilter. After Filtering the first line with data is j25. How do I tell it to step down to the first filtered cell without strictly defining the cell?


Posted by Mark W. on June 21, 2001 8:59 AM

This is more of a VBA question...

Why not have your VBA code do the equivalent of
Control+Home followed by Down Arrow.

Posted by Jonathan on June 21, 2001 9:25 AM

Re: This is more of a VBA question...

Posted by Jonathan on June 21, 2001 9:34 AM

Re: This is more of a VBA question...

Because if I do that then it takes me back to column A and the data I need is in column J.

Posted by Mark W. on June 21, 2001 9:43 AM

Re: This is more of a VBA question...

Okay, then why not select your header in column J,
and then perform Down Arrow?