| Home |
| Search |
| Today's Posts |
|
#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. |
| 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 | |||
![gocush[_28_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
