I tried this before posting the query.
I have a column called Price. The column can allow only Numeric. THis is being done in Excel validation and it works when the user is entering the value manually.
suppose, user copy paste the data, the validation is over-ruled and column takes those value which is wrong. In order to validate, I am running macro at form level, where all the cell data is validated.
Now i want to show the count of empty cells and the number of invalid data being entered in the column
Plz help me