Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
i'll add a wee bit, cos i just changed it(a bit that didn't make sense
before), and add a bit to the case, so you have an idea ...... Do While ActiveCell.Value < "" Range("J" & i).Select Select Case ActiveCell.Value case 1 A = "65" case 2 A = "50" .... .... End Select ...... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Selecting Multiple items from drop down list | Excel Discussion (Misc queries) | |||
Selecting multiple items on Listbox | Excel Programming | |||
Paste Multiple listbox items starting at ActiveCell | Excel Programming | |||
Help: Activecell within Do loop problem | Excel Programming | |||
Selecting Multiple items in ListBox | Excel Programming |