| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
creation of name range without selection of cells
I used the following
row1 = Sheet3.Range("B5").End(xlDown).Row ActiveWorkbook.Names.Add Name:="task1summary", RefersToR1C1:= _ "=Summary!R5C2:R" & row1 & "C2" ListBox2.RowSource = "task1Summary" I wanted all within program -- Jim at Eagle |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| duplicate listbox selection to range of cells? | Excel Programming | |||
| random selection from a range of cells | Excel Worksheet Functions | |||
| Excel VBA - Range(Selection, Selection.End(xlDown)).Name issue. | Excel Programming | |||
| Creation of a range with no specified address | Excel Programming | |||
| Excel - Copy range of cells based on Combobox Selection | Excel Programming | |||
Threaded Mode
