View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Alec H
 
Posts: n/a
Default If.....Then GoTo.......


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