Share via

Excel VBA for Populating Left Footer

Anonymous
2019-10-07T14:53:15+00:00

I am no expert in VBA.  I usually just copy and try stuff I get from web searches on the problem at hand.  Now I am trying to populate a left footer and then format it.  The end result should read:    Prepared by: EndUserName with a Arial font and point size of 10.  I have a function in cell A57 which reads =username() and is working fine to get the end user's name.

The code below works fine, but now I would like to add the text "Prepared by:" in front of the end user's name.

Sheets("Template").PageSetup.LeftFooter = "&""Arial""&10 " & Range("A57").Value

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2019-10-07T15:38:52+00:00

Then try

Sheets("Template").PageSetup.LeftFooter = "&""Arial""&10 " & "Prepared by: " & Range("A57").Value

Was this answer helpful?

1 person found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-10-07T20:05:21+00:00

    Perfect !  Thank you so much !

    Was this answer helpful?

    0 comments