copy and paste - what is wrong?

[earp_]

Hi,
i'm trying to copy from cell F to cell N from line 11 to down.
from cells F11 to N11 I have some datas that i get with formulas.
So I want to update the rest of the cells copying the formulas from F11 to N11 down to the columns.
I wrote this

Worksheets("pdf").Range("F11:N11").Copy
Worksheets("pdf").Range("F65536:N65536").End(xlUp).Offset(1, 0).PasteSpecial xlValues
Application.CutCopyMode = False

but it copies just the value of F11:N11 and not the formulas.
Any suggest?

 

[Mike Blackman]

That's because you're using pastespecial xlValues.

Perhaps you should be using xlFormulas?

 

[earp_]

How?

 

[Mike Blackman]

Try:

Worksheets("pdf").Range("F11:N11").Copy Destination:=Worksheets("pdf").Range("F65536:N65536").End(xlUp).Offset(1, 0)
Application.CutCopyMode = False

or

Worksheets("pdf").Range("F11:N11").Copy
Worksheets("pdf").Range("F65536:N65536").End(xlUp).Offset(1, 0).PasteSpecial xlPasteFormulas
Application.CutCopyMode = False

 

[earp_]

It works good with the first quote. I didn't try the second one.
Thanks.

 

[Mike Blackman]

No Problem