Setting Header/Footer issues

Hi Folks

I'm trying to set the header/footer before printing. The issue only a minor one, but still annoying:

In the picture below, the left header has an indent of 1 character, which is the actual issue.

Attachment 23218

In my code I define a string for the left header, which doesn't contain any blank spaces. However, when looking at the page setup for headers/footers, there's a preset list that shows my string with a leading space.

Any ideas how to get rid of this?

Below are the relevant lines of code:

Code:

---

strLeftHeader = "&B" & "My Company Name" & "&B" & vbLf & wbRüstplan.Name

---

Code:

---

ws.PageSetup.LeftHeader = "&L &""Calibri Light"" &09" & strLeftHeader

---

See if this works any better

Code:

---

    strLeftHeader = "&B" & "My Company Name" & "&B" & vbLf & "wbRustplan.The.Name"
    ActiveSheet.PageSetup.LeftHeader = "&L&""Calibri Light""&09" & strLeftHeader

---

Thanks very much Paul, that works :)

Good -- it was the space after the &L