I don't use excel much, but my access vba calls on excel to excute some code. how do i test for an empty cell? i tried using isnull, = null, = "" all of which didn't work.
I've been there too. It can be a pain, but if you always account for the possibility of embedded spaces in your cells, when coding with Excel, then you should be fine.