View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default need some select case guidance

i use the following and it works fine in my code:

Case Is = "Requests"
vtype = "R"

Case Is = "Approvals"
vtype = "A"

now i want another case to include both R and A

tried:

Case Is = "All"
vtype = "R" or "A"

didn't work, evaluates to acting on every cell value..

can some help me so i can check whether the value in a cell is either an R or an
A and execute the code.
--


Gary