So Ive got some experience in programming, just not with Excel & VBA and Im trying to do a bit of error checking on a quote form in Excel. I'll give you the code first:
Sub errorCheck()
If Cells(N, 23).Value = 1 Then
wRow = 74
For Row = wRow To 22 Step 1
If Cells(C, Row).Value = Cells(N, 24) Then
For Row2 = wRow To 22 Step 1
If Cells(D, Row2).Value = Cells(N, 25) Then
End If
If Cells(D, Row2).Value <> Cells(N, 25) Then
If Cells(f, 11).Value < 500 Then
MsgBox "Custom film sizes must be greater than 500 pounds."
End If
End If
Next Row2
End If
Next Row
End If
End Sub
Basically I have a column that has acceptable sizes and gauges of film. The for loop is supposed to run through the size column and if it matches up with an acceptable size it will then continue to the nested for loop to check gauge. If the gauge matches it should dump out of both loops but if it doesnt, it has to check one last cell (material weight) and if it is less than 500 pounds it should popup an error msg, otherwise, dump out of the loop(s).
Im getting a 400 error when I test it and Im clueless as to what is going on.
Thanks for the help
Bookmarks