How about some separate cells to some sequence cells?
e.g from Sheet2 cells "A1", "B9", "C100" to Sheet1 cells D1 to D3 ?

"Jim Thomlinson" ...
If all you want is the value and not the formula then you don't need to
copy
at all...

Range("A1").Value = Range("B1").Value

Range("A2:A10").Value = Range("B2:B10").Value

--
HTH...

Jim Thomlinson


"jimmy" wrote:

Which command is copy the cell value instead of the formula?

Thank you