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
|