Hi all,

I am very novice in VB. I need help with macro that will display message..

see below table. if any Nos of records more than ZERO(0) then display "OK" else "NOT OK".

Tabs Nos of Records
Tab1 16276
Tab2 132
Tab3 124
Tab4 33261
Tab5 128
Tab6 133
Tab7 0
Tab8 133
Tab9 133



something like...

Sub test()


If Sheet1.Range("B1:B10").Value > 0 Then
MsgBox ("OK")
Else
MsgBox ("Not OK")
End If


End Sub