Offset delivers value error with Named range
I just noticed that you said you were trying to pick members of that
grid. Maybe you should use X and Y as the second and third parameters,
e.g.
=OFFSET(MyGrid,X,Y,1,1)
which will refer to individual cells on row X+1 and Y+1 of the grid,
or use
=OFFSET(MyGrid,X-1,Y-1,1,1)
if you want the cell at (X,Y) rather than (X+1,Y+1).
HTH
Declan O'R
|