LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming,comp.apps.spreadsheets,microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default Question: Cell formula or macro to write result of one cell to another cell

Excel-97 (SR-2)

This is a long term problem that I have with Excel.

I mostly write worksheet applications that have plenty of
user-configurable parameters up front. This is fine for interactive
work and what-if scenarios.

However many of these turn into situations where I then want to scan
through parameters where it would be nice to insert new values into
the parameter cells under program control (either via a worksheet
cell, or using a macro).

There are far simpler cases over and above this that could benefit
from this too.

So is there an implementation of

[G15] = Assign( H15, A15) // H15 = Content of A15 ?

The point being that I don't want

[A15] = H15

for reasons that several donor cells could write into A15 (I know this
raises the issue of precedence, but there could be a simple resolution
for this based on donor cell position).

TIA,
Fred.
 
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
Macro:- Find first blank cell and write text Mac0001UK Excel Worksheet Functions 4 May 17th 09 02:34 AM
Concatenate text cell and formula cell result GoinCrazy Excel Worksheet Functions 4 November 26th 08 04:27 PM
How do I write an Excel macro when the cell range changes weekly? AT Excel Discussion (Misc queries) 3 December 12th 07 11:46 PM
Removing a formula from a cell once the result is in the cell jpolzner Excel Worksheet Functions 2 April 15th 07 02:36 PM
How do I write the IF function to reflect the result in one cell? AMBO Excel Worksheet Functions 8 October 24th 06 07:32 PM


All times are GMT +1. The time now is 07:43 PM.

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"