Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Case Select
Hello
I am trying to modify existing code On Error GoTo ws_exit: Application.EnableEvents = False For Each cell In Me.Range("F2:IV2") Select Case UCase(cell.Value) Case "Cat": ColorCell UCase(cell.Value), cell, 39 Case "Dog": ColorCell UCase(cell.Value), cell, 40 Case "Fish": ColorCell UCase(cell.Value), cell, 35 Case "Horse": ColorCell UCase(cell.Value), cell, 36 End Select Next WS_exit The cases will be the same Cat,Dog,Fish,Horse. However if F1:IV1 = "CAR" me.range is F2:IV2 and if F1:IV1= Numeric then me.range is F3:IV3 Thanks for your help Kelly |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
select case | Excel Discussion (Misc queries) | |||
Select case | Excel Discussion (Misc queries) | |||
Case Select | Excel Worksheet Functions | |||
Case without Select Case error problem | Excel Discussion (Misc queries) | |||
Need help on Select Case | Excel Worksheet Functions |