I am wondering how to capture a single value in VBA using this kind of notation:
"= Round(constants!AO" & i & ",constants!AP" & i & ")"
The problem is that I can capture the cell in question but the cell value is changing in real time.
I just want to be able to capture a single value at the "event" moment; again, I would like the form to be in the form above if possible.
I think what I am looking for is a copy and paste (values only) just before the line of code above.
Copy from Column A to Column B would be a helpful example.