Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how can I get the name of the active worksheet?
Hi all:
I have a workbook that has up to 30 sheets, i.e. one sheet for each day of the month. For ex.: Nov1, Nov2 and so on. I'm averaging values in cell AA32 by =AVERAGE(Nov1:Nov2!AA32) As the month progresses a new sheet is added, i.e. I copy the last sheet, say Nov2 and get Nov2(1) I rename it to Nov3 and now I have to go to cell AA32!Nov3 and edit Nov2 in the average formula to Nov3 Is there a way to get the name of an active sheet without using VBA? Tanks in advance, /mark |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to protect a worksheet from being copied to another worksheet | Excel Discussion (Misc queries) | |||
Search a worksheet, extract rows using a list from another sheet | Excel Discussion (Misc queries) | |||
Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
Worksheet Function - Find? | Excel Worksheet Functions | |||
copyright and worksheet protection | Excel Discussion (Misc queries) |