If.....Then GoTo.......

A

Alec H

Hi,

Stuck again..:confused:

I have a line of code that reads

If (P20) < 1 Then GoTo ????

I want the ???? to refer to the last line of the Sub which is..

Sheets("Customer List").Select

In other words to miss out all other lines of the code and go directly
to the last line. I keep getting told to either refer to a line label
or a line number, currently the code does not have line numbers (I
think) and I dont know how to create a "label" that refers to a line
within the code.....


Help.
 
T

tdols

replace the ??? with anyname followed by ":" so for example Exitthis:

code
-
-
Exitthis:
sheet1. do something
End Sub
 
K

Ken Johnson

Hi Alec,
Write a label after the GoTo and then before Sheets("Customer
List").Select
For example:

If (P20) < 1 Then GoTo SKIP

rest of code...

SKIP:Sheets("Customer List").Select
End Sub

Note the : after the label SKIP
The SKIP label does not affect the normal execution of the last line
when (P20)>=1
Ken Johnson
 
R

R..VENKATARAMAN

just before the line
Sheets("Customer List").Select
type
line1:
(i.e line1 and colon)
the original line should be
if range("P20")<1 goto line1
 
Top