Another excel vba question

[A[L]C]

Hi all...

Ive got a for each, which I want to have an if statement in, and if the if statement is true, I want it to skip that oject and move to the next one.... is that possible? ie

For Each n In ActiveWorkbook.Names
'For each Named Range in the workbook, run the function to check if it is empty
                             
    If Not Worksheets("NewStarterClear").Range("D4").Value = "No" And Strings.Left(n.Name, 6) = "NS_cl_" Then
    'Clear section is not required so do not check clear values
        [COLOR=Red]Next n[/COLOR]
    Else
        RangeIsEmpty (n.Name)
    End If
Next n

 

[A[L]C]

Ahh dont worry, im now using a GoTo label.

Is there a better way to do it?