Thank You..
One more question, How to set the display to a specific sheet cell where
outside the screen when the sheet activate? e.g cell AX100....

"Gord Dibben" <gorddibbATshawDOTca
...
Jimmy

Something like this..........

ActiveSheet.Range("B2").Resize(10, 10).Value = _
Worksheets("Sheet2").Range("A1:J10").Value

Or more simply.........

Range("B2").Value = _
Range("A1").Value

which bypasses using the Clipboard (and is analogous to Paste
Special/Values)


Gord Dibben MS Excel MVP


On Sat, 3 Mar 2007 03:53:54 +0800, "jimmy" wrote:

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

Thank you