| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there an INDIRECT function for a RANGE?
I'm trying to find the equivalent of the INDIRECT function, but instead of a
cell location, I'd like to "build" a Range. As an example, I'd like to convert the following text, "CONCATENATE("Sheet","'!A1:B4") to a range that Excel can understand. If this were simply a cell reference, then the text string could be the argument for the INDIRECT function. Is there a way to do this? Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions | Excel Worksheet Functions | |||
| function like INDIRECT to return a range? | Excel Worksheet Functions | |||
| can I use Indirect function within range definitons for names? | Excel Worksheet Functions | |||
| Indirect Range | Excel Worksheet Functions | |||
| How to paste INDIRECT function to range of cells? | Excel Worksheet Functions | |||
Threaded Mode
