Copy value
 

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

Thank you

Copy value
 

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

Copy value
 

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

Copy value
 

Jimmy

Worksheet event code.

Private Sub Worksheet_Activate()
Application.Goto Reference:=Range("AX100"), Scroll:=True
End Sub

Right-click on the sheet tab and "View Code"

Copy/paste into that sheet module.


Gord Dibben MS Excel MVP

On Sat, 3 Mar 2007 05:41:04 +0800, "jimmy" wrote:

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
m...
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

Copy value
 

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

Copy value
 

You received two excellent answers that avoid using the clipboard. If you
actually want to do a copy and paste

worksheets("sheet1").Range("A1").copy

Worksheets("sheet2").Range("B9").PasteSpecial xlValues

(done in two separate commands).

--
Regards,
Tom Ogilvy


"jimmy" wrote:

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

Thank you

Copy value
 

Got it....thank you

"Gord Dibben" <gorddibbATshawDOTca
...
Jimmy

Worksheet event code.

Private Sub Worksheet_Activate()
Application.Goto Reference:=Range("AX100"), Scroll:=True
End Sub

Right-click on the sheet tab and "View Code"

Copy/paste into that sheet module.


Gord Dibben MS Excel MVP

On Sat, 3 Mar 2007 05:41:04 +0800, "jimmy" wrote:

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
om...
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

Copy value
 

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

Copy value
 

If you can do it manually, you can do it with the code I gave you.

--
Regards,
Tom Ogivly


"jimmy" wrote in message ...
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