Hello, I need to test a cell to see if it contains anything. If not
will delete its row. Sometimes the cell is "empty" and sometimes it i
"null". Testing for both seems like too much. I will reuse this cod
over and over.
My question is, is there a way I can make each cell not containin
info "null" or "empty" so I just have to test for one of them. M
thought is to make a sub that will go through the sheet and make eac
non-used cell "null". When I go to test later I can then just test fo
each cell being null. Or if there is some simpler way to test for bot
instead of isNull(cell1) or isEmpty(cell1). I could make my own su
that does it, but I don't want to reinvent the wheel if one is ou
there.
Thanks

--
Message posted from http://www.ExcelForum.com