outputting values to a range from one formula

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Shafee (Shafee.1df3k5_at_excelforum-nospam.com)
Date: 09/30/04 

Date: Thu, 30 Sep 2004 17:21:20 -0500

I wish to generate a table automatically by means of a single
formula that applies an iteration on a starting given value with
a given step, and the computed values are posted/entered
automtically into cells from a given cell onwards, say below
it, until the computed value reaches a certain given limt.
This is somehow the inverse of INDIRECT or of OFFSET. These
can pull values from a variable addresses of cells. What I need
is to push values into a variable addresses of cells.

Can anyone help me on that??

Thanks. :confused: 

-- 
Shafee
------------------------------------------------------------------------
Shafee's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=14896
View this thread: http://www.excelforum.com/showthread.php?threadid=265293

Relevant Pages

  • Tricks With Iteration
    ... timestamping changes to cells and things like that. ... worksheets I solve these with iteration without using macros, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Workdheet.BeforeChange
    ... As I said then use the Worksheet Change event to capture the contents before the change, however on the next iteration this will be overwritten, and from what you now tell us it could be any one of 100+ cells. ... You could use the Worksheet_SelectionChange(ByVal Target As Range), ...
    (microsoft.public.excel.programming)
  • Re: UDF that participates in circularity always dirty
    ... Excel determines that it has circular references when the dependency chain ... cannot be purged of uncalculated cells. ... That reference IS a dependency. ... If you have Iteration checked then after Excel has used its conventional ...
    (microsoft.public.excel.programming)
  • Re: use excell to find root of function
    ... Another option is to use Iteration. ... Cells A1:C1. ... Due to the nature of your equation, ... Sub Demo() ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Tricks With Iteration
    ... Peo Sjoblom ... > timestamping changes to cells and things like that. ... > worksheets I solve these with iteration without using macros, ...
    (microsoft.public.excel.worksheet.functions)