command to do "nothing" in If/Then statement? #2

[Janis]

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,

[[email protected]]

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,