View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
wayliff[_7_] wayliff[_7_] is offline
external usenet poster
 
Posts: 1
Default Data Filter Function in VBA


Is there a function or command using VBA that enables the Data Filters
for a certain range....but that does not disable it if it was there in
the first place.
Have not been able to figure that one out.

Selection.AutoFilter

I have tried using the line above but the filter is removed if it was
there before.
Just want to ensure that the filter is always present for a range.

Thanks.


--
wayliff
------------------------------------------------------------------------
wayliff's Profile: http://www.excelforum.com/member.php...o&userid=29860
View this thread: http://www.excelforum.com/showthread...hreadid=500683