Ron,

The operation to use is to set a filter, just like you would do in the GUI. The method to use on the selected range is variant 2 of Autofilter (in my Excel 97 help). It's easy to select a range that covers the whole table. If you know that B2 is part of it the code is:
Range("B2").Activate
ActiveCell.CurrentRegion.Select

I leave the details of the remaining part to you to program.

Hope this helps.


Kees