I am using Cells.ClearContents(Int32, Int32, Int32, Int32) to clean up a range of cells.
The method works fine, however, I noticed that it deletes the formulas as well.
Is there a method that clears a cell range while also preserving the formulas?
Alternatively, is there a method that checks if a given cell contains a formula?
I’m thinking of changing the way I clear the content. I could iterate over each cell and clear it if it doesn’t contain a formula.