will do, tried chr(10) and sent it to them yesterday. have not heard back yet.

--


Gary Keramidas
Excel 2003


"OssieMac" wrote in message
...
Hi Gary,

I am a bit confused by what you mean by a "label in a cell". Do you mean
simply text in a cell where the text is wrapped and includes a line feed? If
so, use vbLf in lieu of vbCrLf. vbLf is the same character that is inserted
when you use Alt/Enter in the interactive mode to insert a line feed in a
cell.

--
Regards,

OssieMac


"Gary Keramidas" wrote:

i use vbcrlf when i create a label in a cell.
anyone know why i don't see the non-printable character (box) in the cell but
when i
run the code at my client's site, the box is visible?

--


Gary Keramidas
Excel 2003


.