| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy value
Which command is copy the cell value instead of the formula?
Thank you |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A visual basic value copy BUG?? - accounting format has copy problem!! | Excel Programming | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| copy formulas from a contiguous range to a safe place and copy them back later | Excel Programming | |||
| EXCEL FILE a copy/a copy/a copy ....filename | New Users to Excel | |||
| Code to copy range vs Copy Entire Worksheet - can't figure it out | Excel Programming | |||
![jimmy[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
