Yet another question naming ranges

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

Guest

I have workbook in which I need to import data from a text file. Every time
I import the data the number of rows change so I delete the old data before
importing the new. Now, what I want to do is select the new data and reset
the range of a named range that already exists. I can select the new range
easy enough with :

Range("R3").Select
Range(Selection, Selection.End(xlDown)).Select

After the range is selected how do I rename it? I know its something simple
but I'm stuck here and would greatly appreciate any help.

TIA

Steve H
 
You don't need to select anything.

Range(Range("R3"),Range("R3").End(xlDown)).Name = "NewName"
 
Hi

Maybe you try to use a dynamic named range instead

P.e. you data are in some range like A2:X### with headers in range A1:X1,
and cells in column A are never empty when there are some data in same row,
and there aren't any empty rows in used datarange.

Define named range as
YourRange=OFFSET(SheetX!$A$2,,,COUNTIF(Sheet!$A:$A,"<>")-1,24)
 
Back
Top