P
Paul Moles
I understand it is not possible to use
Data,Filter,Autofilter more than once on a worksheet.
I want a macro to swap the autofilter area between named
ranges. I am running into difficulty because the
autofilter may not be in use on any range in which case
select range then apply autofilter. Alternatively another
range maybe filtered in which case switch off autofilter
for this range select the new range and apply autofilter.
It could even happen that a user doesn't realise they are
trying to re apply autofilter to current area. In which
case status quo remains do nothing.
All easy enough when sitting at the machine myself but not
so easy for users.
Many Thanks
Paul Moles
Data,Filter,Autofilter more than once on a worksheet.
I want a macro to swap the autofilter area between named
ranges. I am running into difficulty because the
autofilter may not be in use on any range in which case
select range then apply autofilter. Alternatively another
range maybe filtered in which case switch off autofilter
for this range select the new range and apply autofilter.
It could even happen that a user doesn't realise they are
trying to re apply autofilter to current area. In which
case status quo remains do nothing.
All easy enough when sitting at the machine myself but not
so easy for users.
Many Thanks
Paul Moles