Thread
:
Can a Macro utilize an auto filter?
View Single Post
#
4
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
Can a Macro utilize an auto filter?
Sub Filterbasedoncell()' from a UNfiltered range
Range("A1").AutoFilter Field:=1, Criteria1:=Range("c1") '"3"
End Sub
Sub Unfilter()
Selection.AutoFilter
End Sub
--
Don Guillett
SalesAid Software
"Susan" wrote in message
...
We're worried that the filter arrow may be too many steps for a user that
is
not very used to excel. In your suggestion, when recording the macro,
would
I record while I did a search in the autofilter? And when I selected
"contains," what would I put in the box for what I'm searching for, the "&
range ("a1")&" reference?
"Don Guillett" wrote:
It seems that you could just tell them to select from the filter arrow.
However, to do what you want, try recording a macro and then using " &
range("a1") & " instead of the recorded reference.
--
Don Guillett
SalesAid Software
"Susan" wrote in message
...
I have column in my spreadsheet and it already has an autofilter
associted
with it. I use the custom auto filter function to do a "contains"
search
for
a particualar string I am looking for. I was wondering if I could
create
a
macro that is associated to a button that does the same thing? I want
an
un-experienced user to be able to type the string they are looking for
into a
text box, click the button, and all the fields in that column that
contain
the string will appear. Is this possible?
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett