These are basically two seperate questions.
I have a For Each loop, with a nested if statement inside, is it possible to have a Next inside the if statement, so that if the IF is true it goes to the next loop. Basic layout shown below, if this wont work can someone show me a Goto statement.
For Each Cell in Range
If cell.value = empty then
My other question is I have a userform creating a number of reports and I want to hide excel in the background rather than having my spreadsheet available. Any way to do this and keep my user form visible?