Determine Value of Autofilter

  • Thread starter Thread starter Evan
  • Start date Start date
E

Evan

People

I have a large spreadsheet with Autofilters switched on.

Elsewhere I have some summary data of the filtered data e.g SUBTOTAL(9,)

But I need to know the value of the Autofilter they have selected from the
dropdown. The reason being I also want (in my summary data) to do some
DLOOKUP of other data stored elsewhere based on this autofilter for my
summary.

Can't seem to find a a way (or create a function) to get this value.

Any pointers?

TIA


Evan
 
in help on auto filter the following is suggested
If .AutoFilterMode Then
With .AutoFilter.Filters(1)
If .On Then c1 = .Criteria1
End With
End If
Filters(1) would be the leftmost filter.
each one to the right will increment up by one.
 

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

autofilter with summary row 1
subtotals with custom autofiltering 1
Autofilter header row 3
AUtofiltering dates 1
Dynamic count on an Autofiltered list 3
Autofilter 10
autofilter fails, not because of blank row 5
autofilter linked in different worksheets 2

Back
Top