I want to use the following excel formula in VBA

=IF(C3=0,"Nil Forecast",IF(E3=0,"Nil Sale",F3/C3))

Actually i am trying to assign the formula to a cell in excel using VBA. But,When i use text strings i.e "Nil Forecast" & "Nil Sale" in the formula the VBA does not understand.

And when i replace the text strings with a reference cell, it works.

Please give me solution for this.

Yogesh

Yogesh

__________________
Yogesh

Try using this

ActiveCell.Formula = "=IF(C3=0," & Chr(34) & "Nil Forecast" & Chr(34) & ",IF(E3=0," & Chr(34) & "Nil Sale" & Chr(34) & ",F3/C3))"


Cheers
Shasur

http://www.dotnetdud.blogspot.com

Thanks. I've been trying since yesterday, the solution given by you is working. Thanks again.

Yogesh

Yogesh