In order to update an Excel tax application for use in a new tax period, I want to start from the completed worksheet(s) of the previous period and delete some/all the already-entered data but leave the formulas intact. I know how to do this in VBA by looping through all the used cells in a worksheet and removing the contents of each one that has a formula.
But this is relatively slow! I could do it faster by using the Excel command to select all cells WITH a formula if there were a quick method of inverting that selection or selecting all the used range that does NOT intersect with that selection. Is there?