Want a Little Change in the Given VBA Code

Hi,
This code copies cell formulas from sheet1 and paste these formulas into a new sheet. I only want that this code should copy values and paste as simple numbers only (without formulas).
Here is the code

Please Login or Register  to view this content.

Will be really very Thankful to you.

Please Login or Register  to view this content.

john beat me to it lol

Please Login or Register  to view this content.

Artik

Hi Sir JohnTopley,

This code worked perfectly as i wanted. In the previous code it was keeping cell format same. But now there is no cell format. No doubt your code worked Perfectly, but if you add this feature too in this code, i will be thankful to you.

Hi Sir Artik,

This code worked perfectly. Code of Sir @JohnTopley and @carlmon also worked exactly like your code.
But i personally liked your code because when i run the code in post #2 and #3, after running, a kind of selection area appears. But when i try your code. After running and completing task there was no any kind of such selection.
Thanks a lot sir

This code worked perfectly as i wanted. In the previous code it was keeping cell format same. But now there is no cell format. No doubt your code worked Perfectly, but if you add this feature too in this code, i will be thankful to you.

Changing the rules of the game during the course of the game? This is not acceptable.

It will no longer be as beautiful as at the beginning:

Please Login or Register  to view this content.

Artik

Hi Sir Artik,

Thank you so much. It worked perfectly.

If you could ignore the width of the columns in the new sheet, it could be beautiful again

Please Login or Register  to view this content.

Artik

Hi Sir Artik,

I need your help in this thread
https://www.excelforum.com/excel-pro...ut-result.html
I want to find those top 10 inputs whose combination gives maximum output result.
I have zero knowledge about VBA. If it is possible with VBA then please try to solve it. If it is not possible with VBA then please guide me how i can solve it with an automatic system. If i try to achieve it manually by changing values one by one then it will take many days or even months for me to get those top 10 inputs with the highest output results.