Execl Macro

[plamuren]

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.

 

[crimlet]

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