Archive of Mr Excel Message Board

Back to Data in Excel archive index
Back to archive home

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?

This is more of a VBA question...
Posted by Mark W. on June 21, 2001 8:59 AM
Why not have your VBA code do the equivalent of
Control+Home followed by Down Arrow.

Re: This is more of a VBA question...
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
Because if I do that then it takes me back to column A and the data I need is in column J.

Re: This is more of a VBA question...
Posted by Mark W. on June 21, 2001 9:43 AM
Okay, then why not select your header in column J,
and then perform Down Arrow?

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.