Simple Formula insert into cell using VBA

[dimitri]

Hi,
I have a pretty simple question. I want to insert the below formula into Cell A1 using VBA.

=A2*8

The number 8 is held in cell B2, but I don't want the formula to read:

=A2*B2

I want the code to look something like:

..."=A2*Range("B2").Value"

I've toyed around with it a for bit but can't get the proper code.

Thanks.

 

[JackDanIce]

Try:

Range("A1").Formula = "=A2*" * Range("B2")

 

[VoG]

Try

Range("A1").Formula = "=A2*" & Range("B2").Value

 

[joe.muckle]

Sorry, whats wrong with:

Range("A1") = "=A2*B2"

 

[dimitri]

Thanks VoG, exactly what I needed.