Hi All,
I am using the offset function to define a named range. It is
=OFFSET('ledger'!$A$2,0,0,COUNTA('ledger'!$A:$A),2 )
While it is not listed in the Name box as a choice for dropdown items, it is
accessible if you type it in.

When I access this range using ODBC, this range is not visible. However,
"normal" ranges, i.e. those visible in the Name Box are seen through ODBC.
Any ideas on how to make that special range visible via ODBC?

Regards
Habib

Microsoft MVP - Great Plains