View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] crferguson@gmail.com is offline
external usenet poster
 
Posts: 91
Default command to do "nothing" in If/Then statement? #2

How about instead reversing your logic:

If Range.Value < placeholder then
'code to do something here
End if


Janis wrote:
I want to cancel out the then part of an if/then but not change anything else.
I want it to do "nothing" instead of what it is doing.
I tried commenting out the then part and I got a run time error so I just
want it to exit the then portion and keep running.

if range.value = placeholder
then exit if

Can you use the command "exit if"
I'm trying to exit the If statement and keep the procedure running but void
out the if/then statement without changing any placeholder references.
thanks,