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

G

Guest

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

crferguson

How about instead reversing your logic:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

command to do "nothing" in If/Then statement? 4
Do While Loop 5
Excel Providing user message when RED X clicked & properly closing application. 2
If statement works here, case doesn't 1
Change_Event troubles, no error & no work. 6
Change worksheet, two trigger cells on one worksheet, only one triggers correctly; using two If stat 3
Trying to run excel vba code when cell value changes from empty to entered value. 1
Snag in invoice generator. How to change the "series" 5

Top