View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default How construct a formula from cells with formulas as text?

I got a template sheet containing "formulas as text" (I have just wiped away
the "=" and formated the cells as text)

In another sheet I want to puzzel it together again as real formulas - I
need to put an "=" and the "formulas as text"

In the template sheet here called Sheet2:
Sheet20.Range("A1:A2") A1: ShtX!$C$29-ShtY!$C$29
A2: ShtX!$C$30-ShtY!$C$30

In Sheet1, where I want to have the formulas visual and working. I want the
result to be the products from the newborn formulas and the formulas visual
just as an ordinary formula in a cell use to.

Like if i would have written:
A1: = ShtX!$C$29-ShtY!$C$29
A2: = ShtX!$C$30-ShtY!$C$30

Easy but complex to describe, maybe? instead of writing the formula, I want
to create it from a "template" with the formula

I'm sure this is easy to do, but I've tried several ways know without
success.

/Regards