import name range form Excel sheet via code??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
What would be the best methode to use??
Click to expand...

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

John W. Vinson[MVP]
 
Back
Top