VBA copy paste

[bjcowen9000]

How can I copy the cell F36 to Cells in range?

I have a loop with a lot going on. After calculations, I want to copy cell F36 to cell F15,then add 5 to cell A1, then copy F36 to F16 etc

Any help?

[Olly]

Please Login or Register  to view this content.

Not sure how to help with "etc"...

[bjcowen9000]

Any ideas why when I do goal seek by setting cell to 0 individually, cell gets set to 0. When I loop, it gets set to a number higher than 0 for different itereations.

Please Login or Register  to view this content.

[Olly]

What's the formula in C31?

What are you trying to achieve?

[bjcowen9000]

It is hard to explain. I am trying to minimize differences between cells by changing a cell that they are dependent on. It seems like the accuracy of goal seek decreases as loop continues

[Olly]

It is hard to explain.

It's even harder to understand Especially without seeing your workbook...

[bjcowen9000]

Do you see a reason why the goal seeker only fully minimizes the first iteration and not the ones after?

Please Login or Register  to view this content.

[Olly]

What's the formula in C31?

(Feel like we're going round in circles, here...)

[Richard Buttrey]

Do you see a reason why the goal seeker only fully minimizes the first iteration and not the ones after?

Why don't you just upload the workbook as requested.