Re : Excel AutoFilter Execution and the ActiveCell thereof

T

TKT-Tang

An Excel worksheet contains an AutoFiltered Range (which in turn is
composed of several Filters).

When the worksheet user executes a Filter, how is it possible to
follow suit that (via VBA coding in Worksheet_Calculate(), perhaps ?!)
the Cell where the Down-Arrow resides (Trade-Mark of AutoFilter) shall
become an ActiveCell ?

Please share your experience. Regards.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Re : Excel AutoFilter Detectable via the Most-Recent Activation of aFilter 0
Re : Excel AutoFilter Drop-Down Window 2
Re : Excel Worksheet_Calculate() & Worksheet_Change() 0
Re : Excel AutoFilter being Toggled of VisibleDropDown 4
Re : Excel to Insert an AutoFilter (at will) 2
Re : Excel VBA Read and Write between the WorkSheet and an Array() 0
Re : Excel CheckBoxes to be activated by VBA 2
Excel Named Formula Weakly Interacts with a Variable Range on the Worksheet 6

Top