Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Separating carriage return data into separate cells | Excel Discussion (Misc queries) | |||
Carriage Return | Excel Worksheet Functions | |||
How do merge two cells with a carriage return in between the two v | Excel Discussion (Misc queries) | |||
Join 2 cells with carriage return in between | Excel Discussion (Misc queries) | |||
Carriage Return | Excel Programming |