Filtering Rows based on A Value Amongst Several Columns of Data

[Ark68]

If I have a range of data, A13: R64, what is the best through VBA to filter only those rows that have a particular value in any of the cells of that range.

Basically, show only the rows which contain the value of A1 in any of the cells in the range.

 

[s hal]

What do you want to do with the items not meeting your filter? Deletion? Autofilter?

I've used autofilter such as the following (loosely - you'd need to modify it for your use):
Range().Autofilter Field:= ______ Criteria1:= _____________

For criteria, it sounds like you have a specific cell in mind, so you could put that there - the rest I'm not as sure about for your example!

 

[Ark68]

Hi shal ...

Yeah, I figured my explanation may have been a bit vague.
The database 18 columns wide, by 64 rows starting at A13. So the range A13:R64. In those cells are several different people's names. What I need to do is isolate all the rows in which one select name occurs in any one (or more) of the 18 columns. Any rows not having that name anywhere within the 18 columns, will be simply hidden. So looks like an autofilter. Not certain whether an autofilter would work in this scenario.

 

[s hal]

Ah, I misunderstood the purpose.. If you have 18 columns the value could potentially come up in, you could probably set up a SELECT query of some sort to query against the list and return the rows in which those values existed.

 

[Andrew Poulsom]

Or use Advanced Filter with OR:

Excel 2003 Advanced Filter Introduction

 

[Ark68]

Hi Andrew ... that is the route I went with!
Thank you all for your suggestions. I have added a bit more to my knowledge base.