| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referencing Sequential Sheets.
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "the-big-john" wrote in message ... T. Valko's post was most helpful. I ended up using something along the lines of: =COUNTA(INDIRECT(A2&"!A2:A50000")) I knew about the Indirect function. I didn't know about the ampersand and quotations. Thanks to all. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When referencing other Sheets | Excel Discussion (Misc queries) | |||
| refer to sequential sheets in a formula | Excel Worksheet Functions | |||
| Referencing Different Sheets in VBA | Excel Discussion (Misc queries) | |||
| Formulas referencing other sheets | Excel Discussion (Misc queries) | |||
| Referencing Sheets in a Formula | Excel Discussion (Misc queries) | |||
Hybrid Mode
