View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Ken Johnson
 
Posts: n/a
Default 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