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?
