Hullo . .
I’m reading an array from a named range: The range contains formulas as well as numeric values
REM get the range
curCarer = Holidays.getCellRangeByName(CarerID)
REM read the data
curCarerData = curCarer.getDataArray()
then update some values in curCarerData, then write it back to curCarer
curCarer.setDataArray(curCarerData)
The changed values all come out ok, but the cells that had formulas have been evaluated and only the resulting number gets written back into the range.
How can I keep my formulas intact ?
