Could you provide more information regarding your 2-dimensional range,
like what is in it, and also the values in X and Y? Are X and Y named
cells or are you using references and are the references absolute or
relative or mixed?

You might also let us know what you are trying to accomplish with the
OFFSET function or the function that uses the resultant reference. As
coded, it refers to a range that contains the top left corner of MyGrid
as one of its corners, and whose height and width are dependent on the
values in X and Y. The #VALUE may be returned by the function that
contains the OFFSET reference.

DOR