+ Reply to Thread
Results 1 to 2 of 2

List of standard variables already included in excel

  1. #1
    Registered User
    Join Date
    11-28-2012
    Location
    Hamilton, Ontario, Canada
    MS-Off Ver
    Excel 2003
    Posts
    3

    List of standard variables already included in excel

    Is there a list somewhere on the inter-web that shows all the standard included variables for Excel.
    Stuff like &[tab], &[date]
    for instance i would like to have &[tab] OF &[num_of_tabs]

    I know that last one is not real...............that's why i would like to see a list of what variables are ALREADY DEFINED and what my choices are.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: List of standard variables already included in excel

    You are talking about codes that go in a custom header or footer. All available codes can be inserted using the buttons, without knowing the codes.

    There aren't many.

    &[Pages]
    &[Page]
    &[Date]
    &[Time]
    &[Path]
    &[File]
    &[Tab]

    If Excel Help isn't helpful enough, this site describes it.

    It is also possible to use macros
    to put just about anything you want into headers and footers.

    I suppose it is possible that there are undocumented/unsupported codes as well, but I don't know any.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1