| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to remove empty cells from Listbox
Private Sub UserForm_Initialize()
With ListBox1 ..AddItem Range("N1") ..AddItem Range("N2") ..AddItem Range("N3") ..AddItem Range("N4") ..AddItem Range("N5") ..AddItem Range("N6") ..AddItem Range("N7") ..AddItem Range("N8") ..AddItem Range("N9") ..AddItem Range("N10") ..AddItem Range("N11") ..AddItem Range("N12") End With End Sub Also is there a way to Addityem in a Range("N1:N12") ?? Corey.... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I shift the contents of the cells up to remove empty cells. | Excel Discussion (Misc queries) | |||
| Remove Data from Empty Cells | Excel Discussion (Misc queries) | |||
| Remove empty cells from named list / validation list | Excel Worksheet Functions | |||
| remove error value when formula exists for empty cells | Excel Worksheet Functions | |||
| How can I remove hidden empty text cells from Excel? | Excel Worksheet Functions | |||
Threaded Mode
