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

You'll find doing this in memory orders of magnitude more efficient
than looping cells directly. Simply 'dump' the entire range to be
vaidated into a variant to get a 2D array. Then loop the array as
desired...

Dim vData, n&, j&

vData = Range("A1:L100")
For n = 1 To UBound(vData)
For j = 1 To UBOund(vData, 2)
'loops row n col by col
Debug.Print vData(n, j)

For n = 1 To UBound(vData, 2)
For j = 1 To UBOund(vData)
'loops col n row by row
Debug.Print vData(n, j)

HTH

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus