locating carriage return within cells
 

chr(13) is a carriage return
chr(10) is a line feed

I'm a little old school and seem to remember someone saying something
along the lines that chr(10) isn't needed anymore, but that could be
wrong.

Cheers,
Jason Lepack

Roland wrote:
I need to locate cells that contain carriage returns. I have no trouble
writing the VBA code to loop each cell and test each character within each
cell. But I do not know what constant to use as I compare each character to
identify carraiage returns. Can someone please tell me the constant that
represents a carriage return?
Many thanks.
--
Roland