Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
additional help
The two lines below are producing errors? I deleted the
first line and re-ran and the second line gave error? With Worksheets("CCFCOK") Set rng = .Range(.Cells(1, 1), .Cells(Rows.Count, 1).End(xlUp)) Set rng = rng(CCFCLC.cmbcc.ListIndex + 1) End With * CCFCLC.cmbfc.Clear Set cell = rng.Offset(0, 1) Do While Not IsEmpty(cell) If LCase(cell.Value) = "yes" Then * CCFCLC.cmbfc.AddItem cell.Parent.Cells(1, cell.Column).Value End If Set cell = cell.Offset(0, 2) Loop |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to add additional columns? | Excel Discussion (Misc queries) | |||
Need additional help | Excel Worksheet Functions | |||
additional row of tabs | Excel Discussion (Misc queries) | |||
Additional column | Excel Programming | |||
Add additional value to a cell | Excel Programming |