M
Matt
Hello all,
I need to be able to get the value of the item the user
selected when they choose an item from the autofilter list
on a column. Does anyone know of anyway to do this?
I tried using the Selection Change event in vba to do this
but that only works if the user selects a cell and doesn't
fire when they have just changed the filter to a specific
value.
What this is for is so that I can change the title on a
chart on another sheet to be the same as the value the
user selected from the filter.. OR if anyone knows of a
formula that would tell me what the value is of the first
or last row in the selection that would work too. The
problem I run into is that the row references change when
the filtered data changes.
Any help is appreciated...
I need to be able to get the value of the item the user
selected when they choose an item from the autofilter list
on a column. Does anyone know of anyway to do this?
I tried using the Selection Change event in vba to do this
but that only works if the user selects a cell and doesn't
fire when they have just changed the filter to a specific
value.
What this is for is so that I can change the title on a
chart on another sheet to be the same as the value the
user selected from the filter.. OR if anyone knows of a
formula that would tell me what the value is of the first
or last row in the selection that would work too. The
problem I run into is that the row references change when
the filtered data changes.
Any help is appreciated...