| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Named range error
I am naming a range based on the output of two ADDRESS() formulas, using the
format =INDIRECT(A1):INDIRECT(A2), where A1 and A2 are outputs of my ADDRESS() formulas. This seems to work, except that when I try to call the named range for a formula, it crashes excel after the first or second try. For example, if I type in SUM(range_name) it crashes about 8 times out of 10; in the 2 instances it doesn't crash, it crashes when I enter COUNT(range_name) in another cell. What gives? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting unique entries and assigning it to a named range | Excel Discussion (Misc queries) | |||
| copy named range to powerpoint | Excel Worksheet Functions | |||
| Dynamic Named Range with blank cells | Excel Discussion (Misc queries) | |||
| Match function...random search? | Excel Worksheet Functions | |||
| Offset Function works in cell, not in named range | Excel Worksheet Functions | |||
Threaded Mode
