Putting Formula in Cell
 

Cell A1 contains the following formula: = J2 & ": " & K1
How do I put this formula in cell A1 using VB?

Thanks,
Bernie

Putting Formula in Cell
 

Range("A1") = "=J2 & ""."" & K1"

Putting Formula in Cell
 

Thanks Allan!

I see my problem is/was the Quotes. My actual formula is quite long, and
the double quotes did the trick.

Bernie

wrote in message
oups.com...

Range("A1") = "=J2 & ""."" & K1"