View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike S[_5_] Mike S[_5_] is offline
external usenet poster
 
Posts: 86
Default 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