BookmarkSubscribe
mpb
Super User mpb
Super User

Re: Checking data with test limits

Removed

Message was edited by: mpb
0 Kudos

Re: Checking data with test limits

Ok I am trying something like this:

0 Kudos

Re: Checking data with test limits

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:

0 Kudos

Re: Checking data with test limits

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