From memory I believe CHR(13) is a carriage return, but you shouldn't need
control codes and I'm not sure how you'd implement it anyway. Pressing
[return] in the footer should drop a line like normal, although pressing
[enter] might be treated as if clicking 'ok' so don't use that.
Paul C

Signature
> what character can I use to create a carriage return in the footer?
>
> Moiz
Moiz
XL 2002.......Start typing and hit ENTER key when you want a new line.
Gord Dibben Excel MVP
>what character can I use to create a carriage return in the footer?
>
>Moiz