Macro. When "If" function right mcaro stops

[marte13]

Hy,

Thera are few "If" functions on one macro. And I want to do when first "if" is right macro would stop and do not continue reading commands further. I don't know is it even possible. If you dont udenstand me:

Sub macro1()

Sheets("Bill").Select
Range("A13").Select
Test = ActiveCell.Cells
If (Test = 0) Then

Sheets("Sąskaita").Select
Range("B13:D13").Select
ActiveCell.FormulaR1C1 = "Car rent"

End If

(IN THIS PLASE I WANT TO DO THAT MACRO STOP IF FIRST "IF" TEST IS TRUE (above) AND WOULD NOT READ SECOND "IF" COMMAND (BELLOW)

Sheets("Sąskaita").Select
Range("A13").Select
Test = ActiveCell.Cells
If (Test = 1) Then
Sheets("Sąskaita").Select
Range("B14:D14").Select
ActiveCell.FormulaR1C1 = "Automobilio nuoma"

End If

End Sub

[AB33]

Please Login or Register  to view this content.