is this copy method equal to this assignment?

[earp_]

Hi i have this

Worksheets("mySheet").range("A10:E114").Copy Destination:=Worksheets("mySheet").range("A10:E114")

and this

Worksheets("mySheet").Range("A10:E114") = Worksheets("mySheet").Range("A10:E114").Value

Do they give me the same result?
I think they do, but I have a crash problem with the second one.Strange because it works for a while and after it crashes.

 

[njimack]

The first one will copy everything - formula, formatting, validation, etc. The second will simply place the specified values in the range.

The only problem I could foresee is if one of the cells in the range you're copying from contains an error.

Also, you should probably use the following:
Worksheets("mySheet").Range("A10:E114").Value = Worksheets("mySheet").Range("A10:E114").Value

 

[earp_]

thanks i will