I have created a form with command buttom (named ADD). Here whatever I add the
information it is storing in another sheet which is basically hidden. The
problem is that if I enter anything wrong then i have to unhide the sheet and
change the required cell.
I want to know if there is any VBcode which identify the wrong data
from stored data and then edit the cell at any point of time? Similarly If
I want to delete entire row then i should do it without unhiding the sheet.
[Note: without unhiding the sheet where the data are stored]