| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I insert a ' } ' into excel so that I can adjust its size? | Excel Discussion (Misc queries) | |||
| How do I insert a ' } ' into excel so that I can adjust its size? | Excel Discussion (Misc queries) | |||
| How do I insert a ' } ' into excel so that I can adjust its size? | Excel Discussion (Misc queries) | |||
| How do I segment a column of data into size ranges in Excel? | Excel Discussion (Misc queries) | |||
| I need a macro that will insert names in an excel worksheet, the . | Excel Programming | |||
Linear Mode
