data validation using VBA, best practice?
I have 11 columns of data I want to validate before printing a report.
The plan is to write VBA code to do validate cell contents in loops. In
this case I want to see non-blanks in some columns, and either numeric
or specific text strings in other columns. Is there a best practice, or
is looping through every row of every column in question and checking
the cell contents standard practice?
TIA,
Mike
|