Excel XP & Win XP
This one is costing me hair.
I am helping an OP from England.
I am working with her file.
I narrowed down my problem so I can explain it simply and without getting
into VBA.
I have a string of cells in a row that appear to be blank.
I select a cell to the left of my problem cell and do End - Right arrow.
Excel stops at the problem cell, that appears to be blank.
I do =Len(That cell) and get zero.
I do =CountA(That cell) and get 1.
All the cells have Conditional Formatting as a function of row number with a
format of color. Most of the "empty" cells act like empty cells. But a
few, like my problem cell, do not.
The code "If ActiveCell.Value="" Then..." says it's True.
The code "If IsEmpty(ActiveCell.Value) Then... says its False.
I can do Edit - Clear - Contents and the problem is solved.
I know I can run a code that loops through all the cells in the used range,
like:
If i.Value="" Then i.ClearContents
and solve this problem, but my question is: What is happening with that
cell? Thanks for your time. Otto