The sad thing is you don't have to guess. Turn on the macro recorder in
Tools=Macro=Record a New macro. Perform the action manually. Turn off the
macro recorder the same way.

Look at the recorded code. You now have the syntax. Good chance that is
how Dan came up with the criteria1 argument.

--
Regards,
Tom Ogilvy


"GrandMaMa" wrote:

Dan;
Thank You!

If I knew the correct syntax's I would be a genius. You have no idea
how many guesses I took.

Granny, Have a Great Weekend!

"Dan R." wrote:

aws.Columns(FrstCol).AutoFilter Field:=1, Criteria1:="<"

--
Dan