I have a macro that inserts a new column and enters a formula in to a cell. Here is the formula part.
How can I have the formula subtract "tms" from Range("tms").offset(0,1) then / by Range("tms").offset(0,1).
In other words I want the formula to remain the same but instead of R9C7, I need it to be 1 col over from "tms" so the formual will always calculate right if new lines get entered. Note: I can't name the cell because that is where the new col gets inserted