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

Thread: Execl Macro

  1. #1
    New Member
    Join Date
    May 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How can I use an excel macro to filter a table in Microsoft excel.
    Here is an example of my table
    Code 20318: AYODELE,M-4519P
    Date Time Call Place Band Rate Distant Duration Cost Code
    dd/mm/yyyy hh:mm Type Number hh:mm:ss $ Number
    26/03/2002 09:14 Otg Benin F Standard 052252680 0:08:48 1.67 20318
    19/03/2002 08:27 Otg United Kingdom 2 Standard 009447833621061 0:15:34 14.08 20318
    18/03/2002 14:55 Otg United Kingdom 2 Standard 009447903681797 0:09:44 8.80 20318
    18/03/2002 07:46 Otg United Kingdom 2 Standard 009447833621061 0:18:35 16.72 20318

    Type Number Cost
    $
    Local etc. 0 0.00
    STD 1 1.67
    IDD 3 39.60
    All Outgoing 4 41.27
    All Incoming 0 0.00

    I will like to remove items in Green.

  2. #2
    Board Regular
    Join Date
    May 2002
    Location
    Ipswich, Suffolk, England
    Posts
    136
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    We cant see the items in green, but to use the filter command in a macro include the code

    Selection.AutoFilter field:=2, Criteria1:=MyValue, Operator:=xlAnd

    the code above sets a sets the filter to use criteria 2 and look for a string helf in the Dim MyValue

    If you could further enlighten us to what you want to do I could expand this further

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
  •