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

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.


--
Alec H
------------------------------------------------------------------------
Alec H's Profile: http://www.excelforum.com/member.php...o&userid=31042
View this thread: http://www.excelforum.com/showthread...hreadid=512643

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

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

code
-
-
Exitthis:
sheet1. do something
End Sub


--
tdols
------------------------------------------------------------------------
tdols's Profile: http://www.excelforum.com/member.php...o&userid=31565
View this thread: http://www.excelforum.com/showthread...hreadid=512643

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

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

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

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



"Alec H" wrote in
message ...

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.


--
Alec H
------------------------------------------------------------------------
Alec H's Profile:
http://www.excelforum.com/member.php...o&userid=31042
View this thread: http://www.excelforum.com/showthread...hreadid=512643

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

Thanks all :)


--
Alec H
------------------------------------------------------------------------
Alec H's Profile: http://www.excelforum.com/member.php...o&userid=31042
View this thread: http://www.excelforum.com/showthread...hreadid=512643