Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
case select and a range
Instead of listing all of the valid values, I would like
to use a range name in a case select statement. Is this possible. Following is the code I'm using without much success. "VV" is the name of the range that contains the values I want to check against. Sub find_match() Select Case cell Case ("VV") counter = counter + 0 Case Else ActiveCell.Interior.ColorIndex = 6 counter = counter + 1 End Select End Sub Thanks for the help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Case Select | Excel Worksheet Functions | |||
Case without Select Case error problem | Excel Discussion (Misc queries) | |||
Select Case | Excel Programming | |||
Need help on Select Case | Excel Worksheet Functions | |||
select case help please | Excel Programming |