BookmarkSubscribeRSS Feed
Choose Language Hide Translation Bar
mpb

Super User

Joined:

Jun 23, 2011

Re: Checking data with test limits

Removed

Message was edited by: mpb

Re: Checking data with test limits

Ok I am trying something like this:

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:

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?