Unable to name certain ranges
Hi Michael,
The result is correct. When you look at the formula in G4 you will
see
=AValues+GInitVal
The value of GInitVal is allways 0.
When you use a namedrange and not a celladdress then name will be
constant.
HTH (sort of)
Wouter
|