Adding in Formula using VBA

[yuenk]

I'm looking for a way to paste in my formula =IFERROR(IF($J2="VSL",EDATE($K2+7,1),$K2+7),IF($K2="ETA TBD","ETA TBD")) if cell L2 has no value. Below I tried to use the following code but I get a Syntax Error when I try to run it.

Please Login or Register  to view this content.

Any help would be appreciated. Thanks

[dougman824]

The Cells() relies on numbers only. So you should have something like

Please Login or Register  to view this content.

So in you case I'm not totally clear on where your I comes in but I think it would look something like

Please Login or Register  to view this content.

With 12 being column L

[AlphaFrog]

To indicate literal quotes within a string, use two consecutive quotes for each literal quote.

Please Login or Register  to view this content.

[jindon]

Cells also take column letter

Please Login or Register  to view this content.

[dougman824]

Yes I apologize I meant to clarify that you are supposed to split up row and column references. At least as far as my experience has shown me you can not reference a row and then "l2" as done above.

[yuenk]

Thank you Jin & Alpha this solved it!