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.
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.