macro recording

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

place a formula in a cell with macro 7
How to subtract a number from a Mergefield? 0
VBA Formula Help 5
Macro to copy value in field and insert it into filter 2
Macro to Edit Contents of Cell 4
I need to change from "=E7" to (equals the current value of E7) 3
Combine 2 columns in a dynamic range into one 7
Copy specific cells to another tab 6

Back
Top