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

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

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

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