View original (French)

Insert cell content into footer

Solved
Floki72450 Posted messages 45 Status Membre -  
Floki72450 Posted messages 45 Status Membre -
Hello,

Here, I have a file with two title cells at the top of the document:
in C1: NAME OF THE SITE
in C3: ADDRESS OF THE SITE

And I would like the content of both cells to be inserted into my footer, both aligned to the left, one on top of the other, like this:

NAME OF THE SITE
ADDRESS OF THE SITE

I have already written this VBA code:

Sub UpdateFooter()
ActiveSheet.PageSetup.LeftFooter = Range("C1").Value
ActiveSheet.PageSetup.CenterFooter = Range("C3").Value
End Sub

But this places the name on the left and the address in the center, how can I stack these two contents?

Thank you in advance to all of you

Best regards

2 réponses

Réponse 1 / 2
Maurice
 
Hello

Modification of your macro

Sub UpdateFooter()
ActiveSheet.PageSetup.LeftFooter = Range("C1").Value & vbLf & Range("C3").Value
End Sub

See you
Maurice
1
Floki72450 Posted messages 45 Status Membre
 
Thank you for your response. If I understand correctly, "Range" means "line" and "vbLf" specifies changing lines?
And if I now want to highlight, or double highlight one of the values, C1 or C3, how can I do that?

Thanks again.
0