I have a problem, using a macro I have already filtered a data set for
a unique value using the autofilter method. I now want to obtain the
unique values from another column within this range. When I try and
apply and advanced filter to generate the unique values it automtically
takes off the advanced filter ruining my filter range.

Is there a way I can do this while still using the advanced filter
method?