I can get this to work using Select Case, but was trying to shorten it up a bit.
No matter the InputBox response, row 4 is delete. I only want row 4 to be deleted if 82, 83, or 84 is entered.
No matter the InputBox response, row 4 is delete. I only want row 4 to be deleted if 82, 83, or 84 is entered.
VBA Code:
Sub Another_Test()
Dim strArea As String
strArea = InputBox("Area? (80,82,83,84,87)")
If CInt(strArea) = 82 Or 83 Or 84 Then
Rows("4").Delete
End If
End Sub