| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Return number of current sheet
I'm looking for a way to create a function to return the current sheet youre
working in. Not its name (Ive found that function), but the number of the sheet. Example: if you have a total of 8 sheets, and youre working on the 3rd sheet, Id like to return the number 3 in a certain cell on the third sheet, 4 on the fourth sheet, 5 on the fifth sheet, etc., and have those numbers update if sheets are added or deleted. Is that possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| make an excel worksheet (sheet 2) open w/ the cursor located in t. | Excel Discussion (Misc queries) | |||
| Return Multiple Results with Lookup | Excel Worksheet Functions | |||
| Find all text instances in a sheet and add one number from each row | Excel Discussion (Misc queries) | |||
| Copy formula...sheet 2 sheet | New Users to Excel | |||
| Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions | |||
Threaded Mode
