PC Review


Reply
Thread Tools Rate Thread

how do I update cels through iteration

 
 
=?Utf-8?B?U2FpbG9y?=
Guest
Posts: n/a
 
      3rd Apr 2007
Hi

I'll appreciate if someone can provide with assistance to do the following.
I have an array of cells with formulas with each cell a function of the
previous one. Now, I want a macro that iterates across the array so that
during each iteration the array is updated using parameters outside the array
and the last values computed in the array. Of course I'll have an if
condition in the array such that if the value of another cell called
iteration is zero then initial conditions are defined, otherwise update the
cells based on previous values. Also, the iteration cell needs to be updated
setting its value equals to the counter in the loop of the macro that runs
the iteration.

Many thanks
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
forward-iteration vs reverse-iteration John A Grandy Microsoft C# .NET 3 28th May 2008 11:13 PM
how do I update cels through iteration =?Utf-8?B?U2FpbG9y?= Microsoft Excel Misc 0 3rd Apr 2007 09:56 PM
the use of $ in cels =?Utf-8?B?bWVl?= Microsoft Excel Charting 1 11th Feb 2006 03:35 PM
Autofill cels based on two dates in adjacent cels William2 Microsoft Excel Worksheet Functions 3 1st Feb 2006 10:57 PM
HOW CAN I GET A VALUE OUT OFF A RANGE OF CELS FROM 7 CELS ONLY ON. =?Utf-8?B?TGF5bG9tYQ==?= Microsoft Excel Misc 1 15th Nov 2004 01:10 PM


Features
 

Advertising
 

Newsgroups
 


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