populating cells using visual basic

[stonypaul]

Greetings,
Could someone please confirm the simple lines of code that will populate nominated cells with string values which are actually formulas, e.g.

Range("A1").Select
ActiveCell = "=B5 * C7"
Range("A2").Select
ActiveCell = "=B10 / 3 - C12"
EndSub

Thank you

 

[VoG]

Try

Range("A1").Formula = "=B5 * C7"
Range("A2").Formula = "=B10 / 3 - C12"

 

[stonypaul]

Thank you yes, that works well, but now I have another problem.
When I try and run this sort of command I get a runtime error.

Range("A2").Formula = "=IF(A1<>"",1,2)"

Is there a better way of making the boolean statement 'A1 is not an empty cell' that VB will like? Clearly it doesn't like the double speech marks ""

 

[stonypaul]

aha got it! I need two sets of quotation marks instead of one set, so "" become """"