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 …...because that ends up adding new cells and removing the old values...cell address without creating a new range, you can utilize the createRange...