Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.. 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create a goto button in excel | Excel Worksheet Functions | |||
Goto in IF statment | Excel Discussion (Misc queries) | |||
Using 'GoTo' in a Macro | Excel Discussion (Misc queries) | |||
Goto a dynamic cell address within a macro | Excel Discussion (Misc queries) | |||
Validation Data & Goto question | Excel Discussion (Misc queries) |