Inserting formula into cell/range refering to a range

I'm sure there are many ways to do this and the way I'm doing it is probably the least efficient but anyways I'm getting an error with this. I want to insert an averaging formula into 1200 rows of a sheet that does not include rows with no entries. Here's my code.

Please Login or Register  to view this content.

Is there an easier way of doing this with say R1C1 or something by just being able to paste a range? I want to take the average of C through DD for all these rows.....


Thanks for any help. Have a nice day.

-Rob

You need to double up quotes within VBA, viz:

Please Login or Register  to view this content.

Still not working with the double quotes

I also tried where I inserted and & on either side. I get a 1004 error application or object defined error

Please Login or Register  to view this content.

Yeah it is. It works when I just use P_Sht.Cells(i, 2)= i... Is there another way I can do this?

Ignore the last message. You were right, It's those spaces.

Thanks for your help.