Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the following code block:
For x = 1 To 10 If RowIsBlank(8) = True Then Application.DisplayAlerts = False Workbooks(TargetFile(x)).Close Application.DisplayAlerts = True Next x End If .... more instructions ... Next x but when I run the code, I receive the expected "Next without For" error message. I need to somehow increment "x" when the IF-block evaluates to True. Can someone kindly tell me how to pull this off? Thanks in advance for any help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
End if without Block If | Excel Worksheet Functions | |||
end if without block if | Excel Programming | |||
End If without Block If Error Help | Excel Programming | |||
if/then block within another if/then block needs a loop | Excel Programming | |||
Block If | Excel Programming |