| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sheet variable
I am looking for a way to use a list value from a data validation (cell D9)
to use as a value in =OFFSET(Merry!C6,COUNTA(Merry!C6:C364)-6,-1) So Merry would be removed and the variable put in it's place. Each time I reference the cell D9 I get a #VALUE! error. Any help would be appriciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How To make a sheet reference Variable (eq: sum(sheet!D2:H2)) | Excel Discussion (Misc queries) | |||
| passing a variable from sheet to form to another sheet | Excel Programming | |||
| selecting sheet name in another workbook by variable (same sheet name) | Excel Programming | |||
| Variable sheet and Formula Sheet | Excel Discussion (Misc queries) | |||
| variable in a link where the variable is the name of the sheet | Excel Worksheet Functions | |||
Threaded Mode
