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
Hello.
Although somewhat new to the forums, I am stuck on a pretty easy macro in excel. I have a spreadsheet with column B having either a 1 or a 2 in it. I basically need to have a macro that hides all rows (in all 3 workbooks, "food", "drug", "conv") that have a value of 1 in column B.
Thanks in advance !
Rob Kormoski

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic