Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is it possible to combine the following :-
For Each MyCell In Sheets("Current Round Detailed").Range("C10:K10") If (MyCell.Value 0 And MyCell.Offset(12).Value = vbNullString) Or _ (MyCell.Value 1 And MyCell.Offset(14).Value = vbNullString) Then MsgBox "xxxxxxxxx" Exit Sub End If Next MyCell For Each MyCell In Sheets("Current Round Detailed").Range("C16:K16") If (MyCell.Value 0 And MyCell.Offset(17).Value = vbNullString) Or _ (MyCell.Value 1 And MyCell.Offset(19).Value = vbNullString) Then MsgBox "yyyyyyyyyyy" Exit Sub End If Next MyCell into something along the lines of :- If For Each MyCell In Sheets("Current Round Detailed").Range("C10:K10") If (MyCell.Value 0 And MyCell.Offset(12).Value = vbNullString) Or _ (MyCell.Value 1 And MyCell.Offset(14).Value = vbNullString) End If Next MyCell Or For Each MyCell In Sheets("Current Round Detailed").Range("C16:K16") If (MyCell.Value 0 And MyCell.Offset(17).Value = vbNullString) Or _ (MyCell.Value 1 And MyCell.Offset(19).Value = vbNullString) End If Next MyCell Then "zzzzzzzzzzzzzzzz" Thanks in advance Sandy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combining AND, MID, and OR | Excel Worksheet Functions | |||
Combining one row into two | Excel Worksheet Functions | |||
Combining look up and last? | Excel Discussion (Misc queries) | |||
Combining Sum, IF and AND | Excel Discussion (Misc queries) | |||
combining IF and AND | Excel Discussion (Misc queries) |