I recorded a macro that copies a formula and special pastes (values). The
formula that is copied changes from week to week based on a number I manually
input.

The problem is when I record the macro to go through the pasted formulas (F2
and then F9 or even ctrl F9) it applies the formula of when I first recorded
the macro and not the formula that is pasted into the cell....

Can anyone help?