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

VBA Code:
--------------------


Case "FIRST", "": TheCol = "I": TheColmn = "J"
Case "SECOND": TheCol = "L": TheColmn = "M"
--------------------




though I'm guessing that a blank cell is to be treated as if *First*
was there


--
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

Reply With QuoteReply With Quote