I have posted this twice before but never got a single response. Is it
possible that this cannot be accomplished?

I have an application where I must have five AutoFilters.

Depending the certain criteria this is what I must do.

' Select Class & Subject to be Filtered!

Dim Course as String

Course = InputBox("Enter The Column Number For The Subject You Teach")

aws.Columns(Course).AutoFilter Field:=1, Criteria1:="European Literature"

' Determine if English has been taken

Dim FrstCol as String

aws.Columns(FrstCol).AutoFilter Field:=1, Criteria1:"" Error =
Expected Name Parameter or Syntax Error

To do this I must Check to see if Certain Columns have data in them, I
must print out all Lines that have a Blank Cell in any of Four Columns.
(These are errors).

I then must copy the lines that match my criteria that is inputed, and
check another column to make sure there are no Blanks(Spaces) in any cell.

I am sure I can figure out the rest without any assistance.

Sorry I am having a difficult time explaining my dilema.

Is it possible to filter out Blank(Spaces) and include the records that have
no Blanks(Spaces) in a column?

I get a halt on the line indicated above.

Thanks

Granny