How to tell if a Word Cell is empty? 1

[dhover]

If there is no text in the cell, Selection.Cells(1).Range.Text = "" returns False.
Why? Because it actually contains a CRLF combination (the end of cell marker?). This can be seen by print the Asc() of the text to the debug window: Debug.Print Asc(Selection.Cells(1).Range.Text)
Now the really perplexing part, is that Debug.Print Selection.Cells(1).Range.Text = Chr(13) returns False.

What am I missing here? Is there an EndOfCell property that I've missed somewhere...or some other way to see if the cell is empty? Maybe I'm looking to hard.

In any case, thanks!
dhover

 

[kaul1jos]

Look at this link

http://www.mvps.org/word/FAQs/MacrosVBA/TableCellEmpty.htm

maybe it will help you

Greetings
Jos

 

[dhover]

Very good! After I posted the question I realized I never checked TechNet. The suggestion there was also to check the length of the text. If it's 2 characters long, the cell is empty...go figure!

It is good to know that Chr(7) is the EndOfCell Marker.

Thanks for the help.
dhover