Thread: Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul W Smith[_3_] Paul W Smith[_3_] is offline
external usenet poster
 
Posts: 11
Default Formula

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