Consulting

Results 1 to 5 of 5

Thread: Printing formulas (on your printer!)

  1. #1
    VBAX Regular Shrout1's Avatar
    Joined
    Sep 2004
    Location
    Maryland, USA.
    Posts
    37
    Location

    Printing formulas (on your printer!)

    Is there some way to print the formulas that are contained in the cells rather than the actual data that is contained within them?

    I have a small workbook that shows me how three different sheets relate to each other (i.e. the formulas reference example pages, etc.) I have to mirror the architecture in this workbook, and it would be a lot easier to do if I could simply print out the formulas.

    Just curious! Thanks!

  2. #2
    VBAX Expert
    Joined
    Aug 2004
    Posts
    810
    Location
    Don't know if this is really what you want, however, it will do the trick....
    go CTRL + "~" , this will change your "normal" view to "Formula" view, then just print it.

  3. #3
    Site Admin
    Urban Myth
    VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,940
    Location
    Here is another option, a UDF to show what your formula is showing ..

    http://www.vbaexpress.com/kb/getarticle.php?kb_id=62

  4. #4
    Administrator
    VP-Knowledge Base
    VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,489
    Location
    Tools/Options/View Tick Formulas

  5. #5
    VBAX Regular Shrout1's Avatar
    Joined
    Sep 2004
    Location
    Maryland, USA.
    Posts
    37
    Location
    Works great! Thanks!

Posting Permissions

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