J
jrh
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.
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.