Excel macro to insert names for ranges, not always the same size..
 

I need an Exel macro to insert names for ranges, not always the same size.
They always start in Colunn A and end in Column U.

Excel macro to insert names for ranges, not always the same size..
 

ActiveWorkbook.Names.Add Name:="MyRange1", RefersToR1C1:= _
"=Sheet1!R2C1:R2C21"

will insert the name: MyRange1
and will refer to the cells A2:U2


"Ocicat" wrote:

I need an Exel macro to insert names for ranges, not always the same size.
They always start in Colunn A and end in Column U.

Excel macro to insert names for ranges, not always the same si
 

You could also try:
Dim myRange as Range

set myRange = Workbooks(1).Sheets(1).Range("A1:U1")
myRange.Name = "MyRange"

"gocush" wrote:

ActiveWorkbook.Names.Add Name:="MyRange1", RefersToR1C1:= _
"=Sheet1!R2C1:R2C21"

will insert the name: MyRange1
and will refer to the cells A2:U2


"Ocicat" wrote:

I need an Exel macro to insert names for ranges, not always the same size.
They always start in Colunn A and end in Column U.