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?

Maybe you could just modify your macro to work on the current selection.

With selection
.copy
.pastespecial paste:=xlpastevalues
end with



mvp4pres wrote:

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?

--

Dave Peterson