Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
This is a very eay macro and yet Excel complains about an "end if
without block if". Why??? Sub check() Count = 0 For i = 1 To 9 For j = 1 To 9 If Cells(i + 3, j + 3) < Cells(i + 26, j + 26) Then Do Cells(i + 3, j + 3).Select With Selection.Interior .ColorIndex = 3 .Pattern = xlSolid End With Count = Count + 1 End If Next j Next i If Count 0 Then MsgBox (Count & "are still wrong") If Count = 0 Then MsgBox ("You have solved it") End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
End if without Block If | Excel Worksheet Functions | |||
Average per block | Excel Worksheet Functions | |||
if/then block within another if/then block needs a loop | Excel Programming | |||
Block If | Excel Programming | |||
Error - End If Without Block | Excel Programming |