Rechecking data validation, without the use of pressing f2 in every cell.

**rajeshturaha** · 07-20-2013, 02:07 AM

Hi to all,
I have a excel sheet that contain data validation for checking character lenth. If i copy / paste a value in that cell the validation doesn't check, until i press f2 for rechecking. The file contain around 1000 cell in each colomn with several rows with different validation viz date check, number check, and every time i have to press f2 in each cell. Any other option, plz help

**:) Sixthsense :)** · 07-20-2013, 02:30 AM

Copy paste will override the data validation. Data Validation will work when manual input occurs. So just add a piece of code to disable copy paste In The Validation Range.

Try some thing like this to restrict copy/paste.

Do right click on sheet tab and paste the below code. Return to excel and check.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If Intersect(Target, Range("A1:A5")) Is Nothing Then Exit Sub
Application.CutCopyMode = False

End Sub