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..
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