PasteSpecial - Formulas

[James_Latimer]

Excel 2003,
Hi, i am not making any excuses but i am fairly new to this!!

I am creating a routine that will 'Restore Parameter Settings' on a workbook.

Basically i have a worksheet with the standard data on it and i am copying and pasting formulas back onto each individual worksheet.

All is working fine except for one section.....

Sheets("StandardSettings").Range("E16:H16").Copy
Sheets("Paroxysmal CNHD Patients").Range("L77").PasteSpecial Paste:=xlPasteFormula

It will do the copy okay but it failr with a 1004 error on the paste line.

I know that i am not writting the code correctly but i have had a look around and i cant see what i should be putting.

Any assistance would be much appreciated.

 

[VoG]

It should be xlPasteFormulas

 

[James_Latimer]

Oh my days!
Thanks VoG, much appreciated.
I shall go and pick up my P45!!!!!

 

[VoG]

This is so easily done and difficult to spot. Here's a hint: in VBA most (but not all) keywords have some letters in capitals. In the VBE type then all in lower case - when you press Enter at the end of a line the editor will capitalise them if they are recognised keywords.