Inputbox in VBA

J

Jeff

Hello,
I have the following VBA Macro:
If WorksheetFunction.CountIf(Range("E394:E709"), Range("E900")) <> 1 Then
Range("E" & i).EntireRow.Delete
Else
Range("L" & i).Value = ans
End If
End If
Next i
I'd like to know if it is possible to have an inputbox in VBA that would
give the option to change the range: (Range("E394:E709")
Thanks,
Jeff
 
Top