Keith

I think it maybe something to do with the way excel headers work.

Thanks for trying - see inline comments, below

"Keith74" wrote:

Quick fix :- lose the chr(10)


I tried this, but it makes no difference

better idea :- check what the value being returned from the textbox is
using ?frmPageTitle.txtTitle.Value in the immediate window.
Textbox value
"1
2
3"
Imediates window value
?frmPageTitle.txtTitle.Value
"1
2
3



"
Using .text instead of .value might help

I tried this, but it makes no difference


Keith