VBA Excel : Membandingkan jika ganjil atau genap, If even or odd statement

Hai sanak saudara,

Kali ini sharing tentang jika angka ganjil/genap di suatu cell maka :

Cekidot :

ThisWeek = Sheets("MASTER FUNCTION").Cells(5, 11).Value ' cell yang jadi patokan

If ThisWeek Mod 2 = 1 Then

GoTo 1 'perintah selanjutnya

End If

Terimakasih,

Mbahe

_____________________________________________________________________

IMPORTANT - This email and any attachments may be confidential and privileged. 

If received in error, please contact Thiess and delete all copies.  You may not

rely on advice and documents received by email unless confirmed by a signed Thiess

letter.  This restriction on reliance will not apply to the extent that the above email

communication is between parties to a contract and is authorised under that contract.

Before opening or using attachments, check them for viruses and defects.  Thiess'

liability is limited to resupplying any affected attachments. THIESS PRIVACY STATEMENT