G
Guest
Hi All,
I have a series of calculations to be performed on a cell value. To do this,
I have written formulae in six rows referencing the data cell, each
performing a different calculation.
I have put the formulae in the cells in the "front end", ie in the worksheet.
The data row, I want to be read in from another sheet, and have written the
VBA code to do this.
Fine 'n dandy.
However, when the data is read in to the row, the formulae in the
corresponding cells in the column do not update.
I have tried to put "activate" commands on these cell references in the vba
code, but no diff. The old formula values sit there on updating the data
cells.
For example:
If cell A1 = N, then cell A1 offset(-1,0) - the cell above - formula says
to evaluate out to 8.
It doesn't: it retains the value of the calculation the first time the code
was run.
I have amended the code to read "On update of cell A1, activate
A1.offset(-1,0)" but that doesn't help.
???
Many TIA's
Matilda
I have a series of calculations to be performed on a cell value. To do this,
I have written formulae in six rows referencing the data cell, each
performing a different calculation.
I have put the formulae in the cells in the "front end", ie in the worksheet.
The data row, I want to be read in from another sheet, and have written the
VBA code to do this.
Fine 'n dandy.
However, when the data is read in to the row, the formulae in the
corresponding cells in the column do not update.
I have tried to put "activate" commands on these cell references in the vba
code, but no diff. The old formula values sit there on updating the data
cells.
For example:
If cell A1 = N, then cell A1 offset(-1,0) - the cell above - formula says
to evaluate out to 8.
It doesn't: it retains the value of the calculation the first time the code
was run.
I have amended the code to read "On update of cell A1, activate
A1.offset(-1,0)" but that doesn't help.
???
Many TIA's
Matilda