View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Offset delivers value error with Named range

Thank you to both Ron and DOR. In the end I used


=OFFSET(MyGrid,X-1,Y-1,1,1) because it keeps the return value to a
single cell range.


Steve