| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
concatenating cell references
I am using a cell reference of the form:
'[January 05 Room Diary.xls]WE 07-01-05'!K17:N20 how can I concatenate such a reference from its filename, sheetnam etc and still use it in a function? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing cell references | Excel Discussion (Misc queries) | |||
| Cell References in Functiona | Excel Worksheet Functions | |||
| Excel: how to formulate conditional cell references | Excel Worksheet Functions | |||
| Transferring cell content between workbooks using cell references | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
