Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste vs PasteSpecial
I can copy/paste with one line of code:
Sub ccz1() Cells(1, 1).Copy Cells(2, 2) End Sub but when I want to copy/pastespecial I use two: Sub ccz2() Cells(1, 1).Copy Cells(2, 2).PasteSpecial Paste:=xlPasteValues End Sub Is there a syntax which performs copy/pastespecial with only one line? -- Gary's Student |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste vs PasteSpecial
I agree that it is weird, but you are correct. One line for a simple paste
and two lines for a pastespecial. -- HTH... Jim Thomlinson "Gary''s Student" wrote: I can copy/paste with one line of code: Sub ccz1() Cells(1, 1).Copy Cells(2, 2) End Sub but when I want to copy/pastespecial I use two: Sub ccz2() Cells(1, 1).Copy Cells(2, 2).PasteSpecial Paste:=xlPasteValues End Sub Is there a syntax which performs copy/pastespecial with only one line? -- Gary's Student |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste vs PasteSpecial
Thanks for your time with such a simple question.
-- Gary''s Student "Jim Thomlinson" wrote: I agree that it is weird, but you are correct. One line for a simple paste and two lines for a pastespecial. -- HTH... Jim Thomlinson "Gary''s Student" wrote: I can copy/paste with one line of code: Sub ccz1() Cells(1, 1).Copy Cells(2, 2) End Sub but when I want to copy/pastespecial I use two: Sub ccz2() Cells(1, 1).Copy Cells(2, 2).PasteSpecial Paste:=xlPasteValues End Sub Is there a syntax which performs copy/pastespecial with only one line? -- Gary's Student |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste vs PasteSpecial
If you're pasting values, maybe you could just assign the value.
cells(2,2).value = cells(1,1).value Gary''s Student wrote: I can copy/paste with one line of code: Sub ccz1() Cells(1, 1).Copy Cells(2, 2) End Sub but when I want to copy/pastespecial I use two: Sub ccz2() Cells(1, 1).Copy Cells(2, 2).PasteSpecial Paste:=xlPasteValues End Sub Is there a syntax which performs copy/pastespecial with only one line? -- Gary's Student -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cut, Copy, Paste, PasteSpecial grayed out. | Excel Discussion (Misc queries) | |||
PasteSpecial | Excel Programming | |||
paste negative time with PasteSpecial | Excel Programming | |||
PasteSpecial Paste:=ColumnWidths | Excel Programming | |||
pastespecial | Excel Programming |