C
Cloudfall
I am using the Advanced Filter to filter out records of companies that
have not supplied a business number in that field (column). To my
astonishment, it isn't filtering them out! Furthermore, on
investigation, using "Edit, Go To..., Special, Blanks", these empty
fields were not selected, so Excel doesn't consider them blank! I can
make them blank by highlighting them and then deleting them, but that's
not the point. You can also copy and paste these things!
1. What are these cells? (Blank? Empty? Null? What?).
2. How do I search for them (so that I can then use VBA to find and
"delete" them).
3. These cells, whatever they are, would make a great party trick.
have not supplied a business number in that field (column). To my
astonishment, it isn't filtering them out! Furthermore, on
investigation, using "Edit, Go To..., Special, Blanks", these empty
fields were not selected, so Excel doesn't consider them blank! I can
make them blank by highlighting them and then deleting them, but that's
not the point. You can also copy and paste these things!
1. What are these cells? (Blank? Empty? Null? What?).
2. How do I search for them (so that I can then use VBA to find and
"delete" them).
3. These cells, whatever they are, would make a great party trick.