Pak heru coba pake goto, ubah sedikit jadi seperti ini.

For hitung = 1 to 10
     If hitung = 5 then
            goto Bawah
     Else
            Kerjakan
     End if
Next

Bawah:



Wassalam,

Suyono

From: [email protected] [mailto:[email protected]]
Sent: Monday, August 10, 2015 3:03 PM
To: [email protected]
Subject: [belajar-excel] Vba For...Next



Dear Para Master,

Bagaimana supaya konter For Next melewati suatu prosedur ketika tidak sesuai 
kriteria, contoh:

For hitung = 1 to 10
     If hitung = 5 then
            Lewati 'Next
     Else
            Kerjakan
     End if
Next

Mohon pengetahuannya

Wassalam,

Heru Safrudin

Kirim email ke