Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I want that is the statement is true, give me a message and stop the macro,
if cell Ki is empty. If the cell contain data I would like to continue with the macro. But when I run the macro for test, if the cell contain data gave me the message and top the macro. What is wrong? For i = 1 To nLastRow + 1 - nFirstRow If Trim(wsSystem.Cells(i, 11)) = "" Or IsEmpty(wsSystem.Cells(i, 11)) Or IsNull(wsSystem.Cells(i, 11)) Then MsgBox "You do not indicated if the System need a Critical or Non-Critical Overall Assessment" Exit Sub End If Next i |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Run a macro on exit | Excel Programming | |||
Run macro on exit | Excel Discussion (Misc queries) | |||
Exit via macro only? | Excel Discussion (Misc queries) | |||
on exit macro | Excel Discussion (Misc queries) | |||
statement to Exit Do if empty row | Excel Programming |