| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to retrieve range in formula?
I need to create a chart of values that are contained in a cell's formula.
For example, if cell A1 has this formula: =STDEV(Sheet1!H1:H10) I want to be able select that cell, click a button, and produce a chart based on the range H1:H10. I will not know what range is specified in the cell's formula until the cell is selected. Is there any way to retrieve the range that's contained in the cells formula? Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Retrieve last non zero value in a range of cells | New Users to Excel | |||
| How to retrieve Named Range name? | Excel Worksheet Functions | |||
| Need formula to retrieve last non-blank cell in range | Excel Discussion (Misc queries) | |||
| Retrieve value from a range of cells | Excel Worksheet Functions | |||
| Formula to retrieve range of dates from a worksheet to calculate d | Excel Worksheet Functions | |||
Threaded Mode
