my macro deletes any row that does not contain the value
of filter1. For obAll, I want the macro to delete any row
that has no value and keep all the rows that have some
value. I currently have:

If obAll Then Filter1 = ""

but this does the opposite, it deletes the nonblanks and
keeps the blanks. Can you tell me what to assign for
Filter1 to mean the nonblanks?

thank you.