Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |