Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Yet another question naming ranges
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Yet another question naming ranges
You don't need to select anything.
Range(Range("R3"),Range("R3").End(xlDown)).Name = "NewName" -- Vasant wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Yet another question naming ranges
Vasant,
Thank you very much. I knew it was something simple. Steve "Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message ... You don't need to select anything. Range(Range("R3"),Range("R3").End(xlDown)).Name = "NewName" -- Vasant wrote in message ... 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Yet another question naming ranges
Arvi,
Thanks for the advice. Vasant's solution fits my needs a little better. Steve "Arvi Laanemets" wrote in message ... 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) -- (When sending e-mail, use address ) Arvi Laanemets wrote in message ... 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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Yet another question naming ranges
But if the range was SELF adjusting you wouldn't need to adjust it.
-- Don Guillett SalesAid Software wrote in message ... Arvi, Thanks for the advice. Vasant's solution fits my needs a little better. Steve "Arvi Laanemets" wrote in message ... 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) -- (When sending e-mail, use address ) Arvi Laanemets wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Quick question on naming a union of ranges | Excel Discussion (Misc queries) | |||
naming ranges | Excel Worksheet Functions | |||
naming ranges | Excel Worksheet Functions | |||
naming ranges | Excel Worksheet Functions | |||
Naming Ranges | Excel Discussion (Misc queries) |