Selecting all rows after applying filter.

Thanks Farid. Not quite there yet though. Do I simply substitute the original code in my OP for your code? Or is yours a seperate sub macro that gets called into the main macro?

Sorry for the noobishness. Still learning.

Ok, so it might help if I put up the whole section of macro of what I am trying to achieve, which is basically this..... but without selecting particular rows, just any that are remaining, bar the 1st row.

Please Login or Register  to view this content.

So what I am trying to achive is.....

On the first Tab, "Converting backlog" I am try to get rid of anything that is not under material grouping "CH01_Converting"
On the 2nd tab, "Pallchek backlog" I am trying to get rid of anything that is not under material grouping "CH01_Pallchek"
On the 3rd tab "Media Backlog" I am trying to get rid of any material grouping that is "CH01_Converting" or "CH01_Pallcheck".

etc..

There must be a simple way of doing this?