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?