LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do i count Text in the Cells, but not formulas. Jman Excel Discussion (Misc queries) 3 September 21st 08 04:15 AM
Construct address as a reference not "text" aka_norm Excel Worksheet Functions 2 May 28th 05 10:42 PM
Construct cell reference for use in formula AG Excel Worksheet Functions 3 May 27th 05 03:21 PM
How do I convert cells containing formulas to text (value returned Kim Excel Worksheet Functions 4 March 28th 05 09:17 PM
I want Excel to allow cells with formulas and unrelated text blueboy Excel Discussion (Misc queries) 9 March 4th 05 12:22 AM


All times are GMT +1. The time now is 07:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"