I have been working on some macro code that uses the End(xlDown) method. I
find that occasionally this method locates a cell two rows below the actual
end of the data. I call the End method on a range containing just the cell
at the top of the column. The blank cells that it indicates are filled are
actually empty; they don't contain spaces or anything like that. I've added
fudge code to back up if End(xlDown) skidded past the real stop point, but
I'm wondering why this happens.

I also find that when I use the Sort method from a range containing an
entire column and using ascending order, it sometimes puts 2 or 4 blank cells
at the top of the resulting column. Again, these are empty cells, not cells
containing spaces.

In both these cases, the cells in the column contain text information
consisting of several alphanumerics, a hyphen, and several digits. Example:
"sys-1163".
--
In theory, there is no difference between theory and practice; in practice,
there is.