Any would have a solution to suggest? I am encountering the same issue... INDIRECT with non continous range... I am stuck there.
Is it considered as a bug or a limitation of Excel? I don't understand.
Anyway, Excel 2003, 2007 and 2010 have same behavior...
Thanks in advance,