Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Highlight dates dynamically AND
  • Excel @ before function names in formulas Excel User tips
  • Progress bar in pure functions CHAR
  • Count cells with condition – multiple conditions COUNTIFS
  • Jan8 date format AND
  • State Abbr with Index+Match+Validation Data Validation
  • Zipcode-State search Formulas - combined functions
  • iframe in Excel (XLiFrame) ADDRESS

WorksheetName and WorksheetsNo UDFs

Posted on February 7, 2012 By ANmar No Comments on WorksheetName and WorksheetsNo UDFs

Once you open the sheet and enable macros, you can use function:

=WorksheetsNo()

To get total number of sheets in that workbook

And use function:

=WorksheetName(1)

To get sheet name for first sheet, and

=WorksheetName(2)

To get sheet name for second sheet and so on, I used the function Row()-5 in cell B6 to get the 1 and in cell B7 to get the 2

=WorksheetName(ROW()-5)

 

 

Download spreadsheet
 
Lookup and References, ROW, User-Defined f(x)s = UDF, Worksheet

Post navigation

Previous Post: Dynamic selection list
Next Post: Multiple-Validations (connected to each other)

Related Posts

  • SimpleANBox Basic Math
  • State Abbr with Index+Match+Validation Data Validation
  • Extract Address into table Formulas - combined functions
  • Insert Blank rows into table using functions CHAR
  • FORMULATEXT to show formulas FORMULATEXT
  • Sheet() and Sheets() Lookup and References

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Recent Posts

  • Calculate above and below me
  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage

Archives

Categories

  • Array formula (1)
  • Formulas – combined functions (58)
  • Google Sheets (2)
  • Non-functions (36)
    • ActiveX controls (2)
    • Conditional Formatting (7)
    • Data Validation (7)
    • Excel User tips (19)
    • Format Cells (6)
    • Graphics (4)
    • Names (3)
  • Standard functions (83)
    • Basic Math (18)
    • Date and Time (16)
      • DATE (9)
      • Hour (1)
      • MONTH (7)
      • NETWORKDAYS (2)
      • TODAY (7)
      • WEEKDAY (8)
      • WEEKNUM (1)
      • YEAR (8)
    • Engineering (1)
      • CONVERT (1)
    • Information (6)
      • CELL (4)
      • ISERROR (1)
      • N (1)
    • Logical (31)
      • AND (5)
      • IF (25)
      • IFERROR (7)
      • IFNA (1)
      • IFS (1)
      • ISERROR (1)
      • OR (2)
    • Lookup and References (36)
      • ADDRESS (4)
      • CHOOSE (3)
      • COLUMN (7)
      • FORMULATEXT (1)
      • HLOOKUP (1)
      • HYPERLINK (2)
      • INDEX (5)
      • INDIRECT (6)
      • MATCH (12)
      • OFFSET (15)
      • ROW (11)
      • VLOOKUP (5)
    • Math and Trig (24)
      • ABS (1)
      • CEILING (1)
      • COUNT (1)
      • COUNTA (4)
      • INT (9)
      • LARGE (2)
      • MAX (1)
      • Min (2)
      • SMALL (3)
      • SUM (3)
      • SUMIF (1)
      • SUMIFS (2)
      • SUMPRODUCT (1)
    • Statistical (6)
      • Average (1)
      • COUNTIF (4)
      • COUNTIFS (1)
    • Texts and Strings (24)
      • CHAR (5)
      • CONCATINATE (1)
      • FIND (1)
      • LEFT (8)
      • Len (4)
      • MID (9)
      • REPT (3)
      • RIGHT (2)
      • SEARCH (9)
      • STRING (1)
      • SUBSTITUTE (2)
      • TEXT (4)
      • TRIM (2)
      • VALUE (2)
  • Uncategorized (2)
  • User-Defined f(x)s = UDF (3)
    • HyperlinkOf (1)
  • Worksheet (16)
  • XLfxs (2)

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
  • Always get 1st name (or last) Formulas - combined functions
  • SimpleANBox Basic Math
  • Calculate above and below me Average
  • Sort list dynamically (functions) COLUMN
  • IF with AND and IF with OR AND
  • Extract Address into table Formulas - combined functions
  • Min Max vehicle Formulas - combined functions
  • Count Unique COUNTIF

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme