Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: what's autofiltered?

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Posts
    197
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Is there a way to see what is being autofiltered?

    The user can autofilter on some columns. Then they choose an option from my menu. The problem is I have to unfilter what they filtered so my process will work. When do though I want to refilter to what they had before the process was done. Can this be done and how????

    Thanks-

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Posts
    363
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Another solution would be to copy the filtered data to a new sheet, unfilter it, apply you procces then delete the sheet.
    It's never too late to learn something new.

    Ricky

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Posts
    197
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks for the suggestion but I found this on another site which is what I was looking for. Here it is if you are curious.

    Function FilterCriteria()
    Dim Filter As String
    Filter = ""
    On Error GoTo Finish
    With Range(Cells(9,2), Cells(9,14)).Parent.AutoFilter
    With .Filters(Cells(9,8).Column)
    If Not .On Then GoTo Finish
    Filter = .Criteria1
    Select Case .Operator
    Case xlAnd
    Filter = Filter & "AND " & .Criteria2
    Case xlOr
    Filter = Filter & " OR " & .Criteria2
    End Select
    End With
    End With
    Finish:
    FilterCriteria = Filter
    End Function


    [ This Message was edited by: hawley on 2002-05-06 12:02 ]

    [ This Message was edited by: hawley on 2002-05-06 12:02 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •