Checking data with test limits

[#1]

Hi Guys,

Is there any way I can check each cell value in a column against the column's test limits and decide if the test has passed or failed? For example if a column has 10 rows of data and if 5 out of the 10 rows fail the test limits for that column, I would like to see a message in a box that says column 'X' failed.

Thanks.

[#2]

Removed

Message was edited by: mpb

[#3]

Ok I am trying something like this:

[#4]

You use the Column function to reference a column
e.g. colRef = Column("test")
To reference a cell within the column you specify the row number
e.g. cellValue = colRef[5]
If you use the For Each construction then [] will reference the current row for each iteration of the loop. The following code will work for you:

[#5]

Why not use the formula editor as explained to you by Lou? Then you wont have to worry about writing code?