Say you have a cell whose value is constrained by a BOUND formula and you want to overwrite its value - NOT the formula - by code.

Instead of shp.Cells(your_cell_name)**.Formula** = ... ,

write shp.Cells(your_cell_name)**.ResultIU** = ...

Interesting enough, if you write a value outside the allowed range, the value gets written into the value parameter of the BOUND formula, but the value of the cell itself is still correctly within the boundaries.

So if you want to know the limits of the cell, you could instead of parsing the formula, set its values to very high and very low values and read the according values.

PS: I haven't yet tried other assignments thant ResultIU.