Last populated column

[AlexanderBB]

LastCol = Split(Cells(rownum, Columns.Count).End(xlToLeft).address, "$")(1)

I'm using the above to get this value and 95% of the time it's correct. But sometimes it returns the Next column, even though there's nothing in it.
By nothing I mean you can't see anything and, for example, say rownum is 1757 and LastCol is "AD"
? "ddd";cells(1757,"AD");"2222"
ddd2222
? len(cells(1757,"AD"))
0
But if I click in that cell and hit Delete LastCol now returns "AC"
How can I find out what is in AD ?
I also tried ? isnull (cells(1757,"AD")) and that was False

 

[alansidman]

How to display or view non-printing characters in Excel?

Is there an option in MS Excel 2010 that will display non-printing characters within a cell (e.g. spaces or the linebreak character introduced by pressing Alt-Enter)?

superuser.com