| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select Case
I would like to apply the "Select Case" to a whole column instead of a single
cell. Could anyone please show me the way. For more information, I apply the function to a single cell by the followings:- Sub Test() Case Is 80 Range("b1").Value = "Good" Case Is 60 Range("b1").Value = "Fair" Case Else Range("b1") = "Unclassified" End Select End Sub Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Case without Select Case error problem | Excel Discussion (Misc queries) | |||
| End Select without Select Case, Block If without End If errors | Excel Programming | |||
| Case Select | Excel Programming | |||
| Select Case | Excel Programming | |||
Threaded Mode
