Does anybody has a macro which would deduct the cell formula of a
selection of cells from original formula.
eg if cell A1= sum(b1:f1)
the macro would leave formula in A1 as : sum(b1:f1) - sum(b1:f1)

so that formula result of A1 would be zero