Change VBA Macros Recording Script to values

[hecgroups]

Hello,

I need to convert the below script which recorded through vba recording. But when i run it is is showing the formulas. I want the actual values not the formulas in the cells.

Can any one help me to write a professionalism script.

Thanks for your help in advance.

Please Login or Register  to view this content.

[Bob Phillips]

Please Login or Register  to view this content.

[hecgroups]

Thank a lot bob it works as i want can you help me for one more thing please.

I have a formula below which i want to change to averageifs from sumif Can you do it for me please.

Please Login or Register  to view this content.

[Trebor76]

Ah, Bob has already provided a nifty solution.

[Bob Phillips]

That formula makes no sense to me, you seem to be dividing one sum by another and subtracting 1 and testing that, but the "" seems to be in the IFERROR function.

[hecgroups]

Thanks for your solution. Topic marked as solved and reputation added.