writing a formula

[Rafael Alvares Tubero]

hello everybody,

I was trying to fill a range with a formula, but from a vba program.
like...

Range("A1") = "IF(B1 <>" & i & ";Yes; "" )"

but where is in red where it should give empty as a answer, it gives a error.

If I wrote directly at Range A1 it would be =IF(B1 <> 0;"YES";"").

But how can I attach at range A1 writing from vba?

Thanks,

Rafael

 

[bertie]

Hi and welcome to the board.

First use commas, not semi-colons
In Excel yes is enclosed in quotation, "Yes", in vba this has to be enclosed in quotations ""Yes"".
In excel the else part of the if statement is "", Again in vba this has to be enclosed in quotations """".

Giving the formula:
Sheets("Sheet1").Range("A1").Value = "=if(b1<>" & i & ",""yes"","""")"

 

[Rafael Alvares Tubero]

Outstanding!!!

Thank you very much!!!