Hi, I want to get a range using referred area. So when I get precedent for a range I want to be able to get that precedent as a range object instead of a referred area object. How can I do that, the only option I have …...xls"); } } In this example, the createRange...setFormula("=SheetTest!B1+SUM(B1:B10)+[Book1.xls]Sheet1!A1"); // Get precedents...