If...Then...Else Loop Error

[rbrizz11]

I am trying to write code for a If..Then..Else loop which will loop through 3 different ranges of check box's (TRUE) which if 1st range is true (open workbook) and run macro1, if 2nd range true (activeworkbook) run macro2...etc, however when I have a space in between rows in my first column, the entire application closes and stops. I think I might be missing a next statement somewhere, or an else statement. Any Ideas?

Please Login or Register  to view this content.

[p24leclerc]

there is nothing missing in your code. The only thing I can see is that if you have no file name to open in the first column (blank cell) when you have a TRUE in the first check box, your program tries to open a file which has but no name.
That's all I can see so far.