I wish to, through code, add a formula to a cell.

A1 = 6
B1 = 12

C1 must read - 6 of 12

Using the following in C1 gives the desired results - A1 & " of " & B1

However when I try to code this using C1.formula = "=A1 & " of " & B1"
there is a problem because the formula must be a string and this changes the
output.

Can anyone quickly give me a solution.

PWS

Paul

on the worksheet: =A1 & " of " & B1

in code: Range("C1").Formula = "=A1 & "" of "" & B1"

Regards

Trevor


"Paul W Smith" wrote in message
...
I wish to, through code, add a formula to a cell.

A1 = 6
B1 = 12

C1 must read - 6 of 12

Using the following in C1 gives the desired results - A1 & " of " & B1

However when I try to code this using C1.formula = "=A1 & " of " & B1"
there is a problem because the formula must be a string and this changes
the
output.

Can anyone quickly give me a solution.

PWS

Hi
try
Range("C1").FormulaR1C1 = "=R[0]C2 & "" of "" & R[0]C2"

--
Regards
Frank Kabel
Frankfurt, Germany


Paul W Smith wrote:
I wish to, through code, add a formula to a cell.

A1 = 6
B1 = 12

C1 must read - 6 of 12

Using the following in C1 gives the desired results - A1 & " of "
& B1

However when I try to code this using C1.formula = "=A1 & " of " &
B1" there is a problem because the formula must be a string and this
changes the output.

Can anyone quickly give me a solution.

PWS