Share via

Excel Footer - multiple cell reference

Anonymous
2010-04-09T12:57:07+00:00

I'm trying to reference two cells in my footer, for example C3 contains the name and K3 contains their account number - I would like both to appear in the footer...I have somewhat accomplished this by placing the info in one cell and using VBA to pull it from the single cell but I would like to seperate the info into two cells...thank you!

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
2010-04-09T16:36:53+00:00

Is this something along the lines you were looking at:

ActiveSheet.PageSetup.PrintArea = ""

    With ActiveSheet.PageSetup

        .LeftFooter = Worksheets(1).Range("C3").Text + " " + Worksheets(1).Range("K3").Text

Pat PS If you found this useful please vote. Thank you:¬)

Was this answer helpful?

2 people found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more