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

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 xxxxxx
then "do nothing"

thanks,

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

Can you please post a little bit of the code you're having trouble
with? Sounds like a logical error...


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 xxxxxx
then "do nothing"

thanks,

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

You will have to comment out every line between "If..Then" and "End If".
Alternatively, if its a huge block of code, cut the entire "If..Then" to
"End If" structure out and paste somewhere to save it (like Notepad, for
instance). You can always copy and paste it back in later.
--
Les Torchia-Wells


"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 xxxxxx
then "do nothing"

thanks,

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

Are you saying that you want the execution of the code to continue if the
argument is True? What do you want to happen if the argument is False? HTH
Otto
"Janis" wrote in message
...
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 xxxxxx
then "do nothing"

thanks,

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

The problem as I can see is in the syntax: 'Then "keyword should be on If
line
If xxxxx then
yyyy
zzzz
else
YyYyY
ZzZzZ
End If
I think cancelling that you want, involves just putting apostrophies like
this ' in fron of yyyy and zzz above.
Or in a brand new code you can do:
If a 0 then
else
YyYyY
ZzZzZ
End If
PS.
Some code uses syntax that places command right after Then, like this:
If a 0 then P=4
no End If, no Else
In such case just modify syntax to have end if and you're done.
HTH
Paul
U¿ytkownik "Janis" napisa³ w wiadomo¶ci
...
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 xxxxxx
then "do nothing"

thanks,