Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing a range in a formula with VB.
I have created a custom formula that takes two ranges as input (i.e. the call
to the function is "=my_function(range1,range2)"). Using VBA I want to read in each of these custom formulas located in a matrix, increment range1 by 28 rows, and then put the resulting formula into a new cell. Does anyone know of a way to do this using VBA? Note that range1 varies for every cell in the matrix. Thanks for the help! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing a range in a formula with VB.
Functions in a worksheet cell can only return values to that cell.
They can't change other cells. jk wrote: I have created a custom formula that takes two ranges as input (i.e. the call to the function is "=my_function(range1,range2)"). Using VBA I want to read in each of these custom formulas located in a matrix, increment range1 by 28 rows, and then put the resulting formula into a new cell. Does anyone know of a way to do this using VBA? Note that range1 varies for every cell in the matrix. Thanks for the help! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing the range for averages with out changing the formula. | Excel Worksheet Functions | |||
Formula referencing a changing range?? | Excel Worksheet Functions | |||
range of Formula copy but not changing the content | Excel Discussion (Misc queries) | |||
How do I set up a formula with a changing range in an excel macro | Excel Discussion (Misc queries) | |||
changing a formula range in visual basic | Excel Programming |