import name range form Excel sheet via code??

[Normanf]

Hi there,

I was wondering how I can dynamiclly define the range of different sheets?
for some Excel sheet i know what the ranges are and ther won't change
either, but I have a few sheets whereas I know that the range of these sheets
will change to either viewer rows or more rows.

What would be the best methode to use??

Regards

Norman

 

[John Vinson]

What would be the best methode to use??

The VBA TransferSpreadsheet method. See the description and the
examples in the online help in the VBA editor.

John W. Vinson[MVP]