Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste values?
I've copied a single area rectanular group of cells.
The program opens a new file. A specific start cell is selected (C9). Now I want to paste values. What is the line of code to paste values? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste values?
Hi
This should do it: Range("C9").PasteSpecial xlPasteValues Regards, Per "xp" skrev i meddelelsen ... I've copied a single area rectanular group of cells. The program opens a new file. A specific start cell is selected (C9). Now I want to paste values. What is the line of code to paste values? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste values?
I get "Pastespecial method of Range class failed" error...any other ideas? "Per Jessen" wrote: Hi This should do it: Range("C9").PasteSpecial xlPasteValues Regards, Per "xp" skrev i meddelelsen ... I've copied a single area rectanular group of cells. The program opens a new file. A specific start cell is selected (C9). Now I want to paste values. What is the line of code to paste values? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste values?
Did you copy the cells before PasteSpecal?
Post your code, so we can see what is going wrong. Regards, Per "xp" skrev i meddelelsen ... I get "Pastespecial method of Range class failed" error...any other ideas? "Per Jessen" wrote: Hi This should do it: Range("C9").PasteSpecial xlPasteValues Regards, Per "xp" skrev i meddelelsen ... I've copied a single area rectanular group of cells. The program opens a new file. A specific start cell is selected (C9). Now I want to paste values. What is the line of code to paste values? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste values?
Probably, the easiest way to do this is to record a macro and view the results:
Range("C9").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "xp" wrote: I get "Pastespecial method of Range class failed" error...any other ideas? "Per Jessen" wrote: Hi This should do it: Range("C9").PasteSpecial xlPasteValues Regards, Per "xp" skrev i meddelelsen ... I've copied a single area rectanular group of cells. The program opens a new file. A specific start cell is selected (C9). Now I want to paste values. What is the line of code to paste values? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change paste to only paste values | Excel Programming | |||
find values in multiple cells and paste row values | Excel Discussion (Misc queries) | |||
can you change the default paste method? (paste values) | Excel Discussion (Misc queries) | |||
Dynamic Copy/Paste Special Formulas/Paste Special Values | Excel Programming | |||
How do i compare values from two sheet and copy & paste if values match? | Excel Programming |