Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have 3 variables named Sell, Buy and Stop that I wish to use in a
sheet named Test. The variable Sell ranges from 1.00 to 1.99 in increments of .01 and would be entered in cell H1 of Test. The variables Buy and Stop range from .5 to .99 in increments of .01 and would be entered in cells J1 and L1 respectively. I have mutual fund closing price data in columns A and B beginning on row 4 and ending on row 7 and ending in row 1700. Various formulas are entered in columns C through P on each row. The result of the variables is in column N for each day on each of the rows from 7 through 1700. I am looking to record the last result of the last day which would be in cell N1700 on the sheet Test. I hope to place all possible combinations of each of the 3 variables into the sheet Test and record the results. I would appreciate the coding for such a task. I use Excel 2002 SP3. Thanks for any assistance offered. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Function not evaluating | Excel Discussion (Misc queries) | |||
Evaluating a range | Excel Discussion (Misc queries) | |||
Evaluating a Sting in VBA | Excel Programming | |||
Evaluating a cell | Excel Programming | |||
Evaluating a range | Excel Programming |