View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
p45cal[_275_] p45cal[_275_] is offline
external usenet poster
 
Posts: 1
Default Skip condition if cell is blank


In a *Case Select* statement, the first *Case *which satisfies gets
executed and code execution jumps to the line after *End Case*. So
1. there is no point in in having the same condition in two *Case
*statements
2. the order of the *Case *statements is important


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?u=558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=202176

http://www.thecodecage.com/forumz