| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing a string to Case statement
My current code reads:
Select Case Cells(i, 8) Case "ABC", "DEF", "GHI" ...... End select Since I have different of these cases I wonder if it is possible to use a variable as follows: Dim CaseVariable as variant Set CaseVariable= "ABC" Select Case Cells(i, 8) Case CaseVariable ...... End select So far I cannot get this working. Is it possible? Please advise. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Passing Query String into MS Excel | Excel Discussion (Misc queries) | |||
| Passing String to Formula1 Method in VB | Excel Programming | |||
| Passing a String in Array to Range as String | Excel Programming | |||
| string passing to DLL | Excel Programming | |||
| PASSING A STRING VALUE | Excel Programming | |||
Threaded Mode
