Copy Paste Issue

[captbluefin]

Strange problem using code we have used for a long time.

We are copy/pasting a formula, and we're seeing the source copy values appear in the pasted range, even though the equations in the source cell are being pasted correctly.

Here is the code we have been using:

Please Login or Register  to view this content.

Take a look at the formula for Range G32 in the code above.
After pasting as in the code above this is the formula in Range G33: =(((D33-B33)*10)+((F33-B33)*10))/2
The formula has been pasted as one would expect. The columns and row get adjusted.

The problem is that the same values that are in G32, H32 and I32 show up in the entire pasted range. Not the calculated values based on the contents of the equation in the cell.

I created the attached example workbook, copied the macro code to it, then ran the code and the values change as they should. I did create an xlsx for the example. The main sheet I use is an xlsb if that makes a difference. Take a look at the attached example sheet. As above, just the values from the source copy appear. Not the values that should appear according to the formula in the cells. Then run the macro code above, and the correct values appear.

But in my main workbook, just values appear. Very odd. Would like to get my main workbook working again.

As always, any help would be appreciated.

Thanks

[jolivanes]

What is the result if you replace this

Please Login or Register  to view this content.

with this

Please Login or Register  to view this content.

and add this at the top of your code

Please Login or Register  to view this content.

I have not tried it so make sure you try it on a copy of your original.

[huuthang_bd]

I guess your workbook is applying manual calculation mode. If that right, change calculation mode to automatic and then retry.

[captbluefin]

I noticed when I saved and reopened the workbook, all the formulas had been applied. I followed huuthang_bd's suggestion. The workbook was indeed set to manual calculation. Switched formulas to automatic calculation and everything works perfectly. Very strange. No one but me works on the coding. There are only 2 of us and I know my employee didn't change the formula calculation setting option. In any event, calculations are working perfectly.

What a relief!!!!!

Many thanks to all who took the time to look. Special thanks to those who responded.

MUCH APPRECIATED!!!!!!!!!!!!