VBA Code to Pass String into Page Header

I've got a template that I am trying to use for multiple reports. Depending on which macro gets run, I want it to put a string into the header so I know which report is generated. Here are the issues that I'm having:

1. I use a picture in the center space of the header and eventhough I want my Report type text to be displayed in the middle of the page, I can't get the text to run ontop of the picture unless it is in the left header field.
2. Since I have to use the left header field, I need to add spaces to the Header to Kick the Text into the center-ish place on the report, but VBA is not liking my " " designation.
3. Finally, the code below works (minus the spacing being done correctly), however I can't get VBA to pass the variable into the header. Therefore, the code below just puts "HeaderName" into the header instead of "Annual Report"

'start header

Please Login or Register  to view this content.

Any ideas?

Maybe: But not sure what you want

Please Login or Register  to view this content.

Try This:

Please Login or Register  to view this content.

You're welcome and thanks for the rep!

If that does it then please mark this thread as solved.