GoTo or Run Code???

**Rick_Stanich** · 04-23-2008, 10:06 AM

My first guess would be a requirement is not being met? In this section of your code you use the same "If" statement twice.

 For i = LBound(requiredCells) To UBound(requiredCells)
     If Range(requiredCells(i)).Value = vbNullString Then
         Range(requiredCells(i)).Value = userInput(prompts(i))
         If Range(requiredCells(i)).Value = vbNullString Then Call Mail_workbook_Outlook_2
    End If
 Next i

I would think that the string "If Range(requiredCells(i)).Value" is not evaluating to "vbNullString".

A second look I see that you reset your "If" satement to "If Range(requiredCells(i)).Value = userInput(prompts(i))", then the second "If" statement would not evaluate to "vbNullString" and the call statement would be ignored.

**jkauffman** · 04-23-2008, 10:36 AM

I see what your saying this is how the code was originally written, I don't write very much VB code but have an understanding of how it works. It is set to exit the sub once it's finished checking all the cells for data. But what I need it to do is call the Email Macro so the excel file is then emailed out, that is where I am having the problem. I can't get it to go from this macro once its done with its routine to the email macro

Thanks

For i = LBound(requiredCells) To UBound(requiredCells)
     If Range(requiredCells(i)).Value = vbNullString Then
         Range(requiredCells(i)).Value = userInput(prompts(i))
         If Range(requiredCells(i)).Value = vbNullString Then Exit Sub: Rem Cancel pressed
     End If
 Next i

End Sub