It happens that Gord Dibben formulated :
DataImport External DataImport Data

Files Of TypeExcel Files.

Drill down to the folder containing your workbook with the named range and
click
OK

You will be presented with "Select Table"

Find your named range and OK

Thanks, Gord! Didn't know this because I've never 'Imported External
Data' from anything other than a database. For anything else I always
use ADO. -Didn't think that's the solution the OP wanted.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc