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?