Application-defined or Object-defined error on Formula entry

[Kaigi]

I'm trying to enter a series of formulas into a worksheet using vba. However, this code is giving me Run time error '1004', along with the description in the title. This is the first formula (they're all relatively similar).

Please Login or Register  to view this content.

Thanks for the help!

[Richard Schollar]

Hi

You need to escape your double quotes:

Please Login or Register  to view this content.

Richard

[Kaigi]

Oh - that fixes it. Thanks