Dear Friends

i am new to vba coding & don't have much experience. but i have created a spreadsheet where in i have already used some coding which is working fine

i want to check whether the value etnered in a particular column is whole no & if it is whole no it should be within 0 - 200 only. if not it should give a error message . i had done it using data validation but now i have used it for some other thing & hence i want a vba code for it.

i tried the following code it si not working 7 it als odoesn to check whether it is within 0 - 200.

If Target.Column = 19 And Target.Row >1 And Target.Row <= 1001 And _
Target.Value <> Int(Target.Value) Then
Cells(Target.Row, Target.Column - 1).ClearContents
MsgBox ("not an integer value")
End If

early reply is appreciated

with regards