On 4/24/2016 9:04 PM, GS wrote:
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

That definitely helps, thanks GS.