Arvi,
Thanks for the info.
The problem is that I want to set up a foolproof method that offers a
consisntent result.
Naming large ranges does not work because users can delete rows, resetting
the range.
However,defining the range as 'ledger'!$A:$R may do the trick.

Regards
Habib



"Arvi Laanemets" wrote in message
...
Hi

IMHO you can use only non-dynamic named ranges, defined as direct cell
references, as source tables for ODBC query. I always define ranges, I
assume to use as query source tables, with a lot of spare rows - you can
always determine in filtering criterias some key column(s) to be Not Null.

There are some other rifes with queries from Excel files too. P.e. I had
the
situation, where I had a lot of dynamic ranges defined, and when I defined
a
fixed named range, with name beginnng with "T" (i.e. it was at bottom of
named ranges list), it wasn't accessible for ODBC. It looks like the
number
of named ranges, from where applicable for ODBC are searched for, is
limited - when I started the range name with other character, so it moved
up
in ranges list, then from certain position (it was somewhere between12 and
20 - don't remember exactly) it was accessible for ODBC again.

Another quirk - when you create an ODBC query from range in same workbook,
then as I found out lately, you must have Analysis Toolpack Add-in
installed
(I suspected MS Query Add-In at start, but it really looks like you need
Analysis Toolpack!!!???). Otherwise you can create the query, but you'll
have problems after you close the workbook and reopen it later, When
refreshing the query, the query wizard opens, and you are asked for source
again and again - unless you cancel.

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"HSalim[MVP]" wrote in message
...
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