Why do you need a macro, why not just use Autofilter in Excel?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"GrandMaMa" wrote in message
...
I have never had to filter a column with a Macro before. I need to select
all of the students with four A's. This part is simple because Column 'L'
will have AAAA in it.

I have never worked with a filter in Excel, but is it better for me to
create another worksheet with just the AAAA students in it, or just
display
the AAAA students in the current worksheet?

Also does anyone know the code for Column = AAAA

This is only my second Command Button project using Excel.

Thanks a Bunch

Granny