I have the following formula in column "I". I have code that puts a range
of values in to column "G". The values must be pasted as "Values" as the
source range contains formulas. When the values are pasted, all the
formulas in "I" return an error. The weird thing is, if I double click any
of the cells in "G" and press enter, the error goes away. Any suggestions
on how to fix this?

=IF(ISBLANK(G3),"",ROUND(IF(OR(H3="cs",H3=""),G3,G 3/$E$3),2))

Hi AD108,

Is tha calculation method being set to manual? Try explicitly setting
calculation to xlAutomatic.


---
Regards,
Norman



"AD108" wrote in message
...
I have the following formula in column "I". I have code that puts a range
of values in to column "G". The values must be pasted as "Values" as the
source range contains formulas. When the values are pasted, all the
formulas in "I" return an error. The weird thing is, if I double click
any
of the cells in "G" and press enter, the error goes away. Any suggestions
on how to fix this?

=IF(ISBLANK(G3),"",ROUND(IF(OR(H3="cs",H3=""),G3,G 3/$E$3),2))

Thanks,

Something strange happened to my outlook, and I thought the original post
may have been lost. I'll try that.


"Norman Jones" wrote in message
...
Hi AD108,

Is tha calculation method being set to manual? Try explicitly setting
calculation to xlAutomatic.


---
Regards,
Norman



"AD108" wrote in message
...
I have the following formula in column "I". I have code that puts a
range
of values in to column "G". The values must be pasted as "Values" as
the
source range contains formulas. When the values are pasted, all the
formulas in "I" return an error. The weird thing is, if I double click
any
of the cells in "G" and press enter, the error goes away. Any
suggestions
on how to fix this?

=IF(ISBLANK(G3),"",ROUND(IF(OR(H3="cs",H3=""),G3,G 3/$E$3),2))