writing in formulas - getting errors

**gryffin13** · 07-23-2012, 11:08 AM

Hi all,
I am trying to set certain cells to contain formulas, but I am getting errors. The code is:

Please Login or Register  to view this content.

As far as I can tell I have 2 problems.
1) after typing in the 4th line of code it highlights the word RUSH and says "expected end of statement". I have no idea why this one is wrong but the others are ok. The text is the only thing that is different, but I don't know why that changes anything...
2) when I comment out that line and try to run it, they are all wrong and I get both "run time error 1004 - application defined or object defined error" and "run time error 438 - object doesn't support this method or property" depending on which line I look at. Can anyone explain what I'm doing wrong? Thanks

**Pete_UK** · 07-23-2012, 11:17 AM

If you want to include quotes in a formula then you have to double-up. Try it like this:

Please Login or Register  to view this content.

Also, you have spelt formula incorrectly on each line.

Hope this helps.

Pete

**gryffin13** · 07-23-2012, 11:22 AM

Wow, I feel like an idiot right now. I can't believe I didn't see the typo. I appreciate the help, but I still get a 1004 error with the typo fixed. Any thoughts?

---------- Post added at 11:22 AM ---------- Previous post was at 11:20 AM ----------

nevermind. I had to add the double quotes that you suggested to the first line as well. Thank you so much.