Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function for counting Worksheets?
I need to know a function that i can enter into a cell that will give me the
total number of worksheets i have in a specific Workbook. it will serve as an invoice number because i create a new sheet for each invoice i have. thank you. -- Jon Robershaw Wardell Builders, Inc |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function for counting Worksheets?
Hi,
Alt +F11 to open VB editor. Right click 'This Workbook' and insert module and paste the code below in. Call with =numsheets() Function numsheets() numsheets = Worksheets.Count End Function Mike "JonWardellBuilders" wrote: I need to know a function that i can enter into a cell that will give me the total number of worksheets i have in a specific Workbook. it will serve as an invoice number because i create a new sheet for each invoice i have. thank you. -- Jon Robershaw Wardell Builders, Inc |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function for counting Worksheets?
Hi,
1. In the same cell in each sheet enter something (anything), say you enter the date into cell A1 on each invoice, then =COUNTA(Sheet1:Sheet300!A1) Where Sheet1 is the first sheet in the workbook and Sheet300 is the last sheet (left to right) in the spreadsheet. When you add a new sheet, insert it between the first and last sheet. If necessary make Sheet300 a dummy with nothing in it. If this helps, please click the Yes button. -- Thanks, Shane Devenshire "JonWardellBuilders" wrote: I need to know a function that i can enter into a cell that will give me the total number of worksheets i have in a specific Workbook. it will serve as an invoice number because i create a new sheet for each invoice i have. thank you. -- Jon Robershaw Wardell Builders, Inc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting data across worksheets | Excel Worksheet Functions | |||
counting data across worksheets | Excel Discussion (Misc queries) | |||
counting function but not double counting duplicates | Excel Worksheet Functions | |||
Counting Worksheets, Second Verse | Excel Worksheet Functions | |||
Help with counting across worksheets | Excel Discussion (Misc queries) |