View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DOR
 
Posts: n/a
Default 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