Results 1 to 3 of 3

Thread: Variables in footers

  1. #1

    Variables in footers



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I was wondering if there was a way to have a variable in a cell/s be used to build footers in worksheets with different page setup settings. I use a formatted spreadsheet as basis for many different specific spreadsheets that need spreadsheet specific information in footer.

    Sent from my SPH-L900 using Tapatalk 2

  2. #2
    Conjurer royUK's Avatar
    Join Date
    Mar 2011
    Location
    Derbyshire, UK
    Posts
    155
    Articles
    0
    Excel Version
    most versions
    You can set Footers using VBA that would take the cell's value
    Hope that helps

    Roy

  3. #3
    Thanks...forced me to just look for a vba solution...after trying to trigger updates based on print event, I had to switch to cell trigger since every print event triggered a long lag...at least the long lag can be minimized by triggering the update once per new customization...still a painfully long lag, but faster than updating 20 worksheet footers.

    Thanks

    Sent from my SPH-L900 using Tapatalk 2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •