Making a footer 2 lines

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Ok currently I have to cells with information. I currenlty have it set to
put one in the left and one in the right footer. I need to put them both in
the let footer one over the other. Any one have any ideas. This is my
current code. Thanks

'Left
Sheets("Report").PageSetup.LeftFooter = Sheets("Data
Entry").Cells(248, 3)
'Right
Sheets("Report").PageSetup.RightFooter = Sheets("Data
Entry").Cells(246, 3)
 
Sheets("Report").PageSetup.LeftFooter = _
Sheets("Data Entry").Cells(248, 3) & chr(10) & _
Sheets("Data Entry").Cells(246, 3)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Last Time Updated in Footer 2
Run and edit a Macro 1
Help Please 7
Adding current date and contents of a cell in the footer 3
Headers and Footers by VBA? 6
Macro to Select All Sheets and Make Change to Footer 2
Working with page footers 1
Macro to Combine Data from Multiple Sheets with Cell References 4

Back
Top