Copy integer from a range with formule

Good Afternoon friends and Masters of VBA Excel
I waste time tryint to find information about how copy range of cells from a sheet01 to sheet02.
But I dont want copy formulas, I want copy only the numbers that those formulas generate.
When I use the code below.. it pick the formulas...
How I can change the code for only pick numbers?

I see that exist Formula=Value
But I dont have clear how use it

Please help me!

Please Login or Register  to view this content.

Thanks for your help.
I get Run-time error '438':
Object doesnt support this property or method

I am using Excel2016 and google say that the problem is caused for excel2003 (add in corrupted).
Other explanation say: You specified a method or property that doesn't exist for this Automation object.

Maybe is a problem with the type of button?
The button I put in PxH sheet and the same problem if I put in PxHpoints.

Debug color yellow in: Sheets("PxH").Range ("D12:O12")

Sorry for ask for your help again.
But please...

Nothing to do with the button, just a bad code …

As a VBA beginner starter :

PHP Code: 

Private Sub CommandButton1_Click()
    Range("PxHpoints!D5:O5").Value2 = Range("PxH!D12:O12").Value2
End Sub 


► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » ! ◄ ◄

Sorry, see my correction.

As you can rewrite your code without any Select neither Selection just direcly working with objects …

Thanks for your time.
Now I have run time error 1004: Select method of Range class failed.
I am surprised that an apparent simple procedure get so hard to solve...
or maybe is a procedure that Vba usually dont use.

No it's common when the initial post is not well elaborated as we can't guess the context, all you forgot to explain …

Did you at least try post #4 ?!

Yes friend, I try all the recomendations and nothing working. Then there is no way that copy the big table and paste only number and work with this Sheets("PxH").Range("D12:O12").Copy Destination:=Sheets("PxHpoints").Range("D5") or some modifications. And the context is very simple, is like you put in a cell: = 10*5 and you want copy that to other sheet/cell and only want pick the "50" and dont pick the formula. If you can do with a cell, sure you can do with a range. Please can you do this master explanation about this concept. I dont find that in any other forum.. I am tired to search and search... books dont have references, too.

Thanks for your time and sorry for boring with this matter.

You are right! I use macro record and it work nicely.
Thanks.

Originally Posted by Marc L

As you can rewrite your code without any Select neither Selection just direcly working with objects …

I don't think it's necessary fot the thread starter.

I think so as a good code does not need to Select anything like a poor code generated by the Macro Recorder,
as working directly with objects is more efficient / faster than using Select …

For such a code, I just advise the OP to directly use the Macro Recorder …