Copy range but only numbers, not formules

[Vladi108mb]

Namaste Friends! I am in this context:

COPYRANGEcells.jpg

And the formulas are:

Please Login or Register  to view this content.

It works but copy formula and I only want the numbers.
How is the right way to do that?

Thanks for your help.

[nankw83]

Hi Vladi108mb ... Try below code

Please Login or Register  to view this content.

PS: Please edit your post, select the code then press the # button from the menu to insert code tags for you

[Vladi108mb]

It works nicely. Thank you very much.

[nankw83]

Thank you for the added Rep. If that takes care of your original question, please take a moment & mark this thread as [SOLVED] from the Thread Tools above your first post