Excel Single Row Checking

[philipq]

I am getting the following error in the below shown code:

Error (RT) in <open ":2991: /6084">Amended Orders AL - VISTA Verification: Exception 0xC0000005. Access violation. Cannot read memory at 0x0. In qm.exe at 0x48C163 (0x400000+0x8C163)

Macro Amended Orders AL - VISTA Verification

Code:

Copy      Help

,;;*******FIND MODEL********
,if y.Find(varModelV b 2|4 ExcelRow(row1))
,,;for j 0 b.len
,,,r2=b[0] ;;***ISSUE HERE****
,,,out F"col={r2.Column} row={r2.Row}"
,,,;color
,,,excelColor=ColorFromRGB(0 255 0) ;;GREEN
,,,f.cellColor=excelColor
,,,y.Format(ExcelRange(r2.Column r2.Row) f)
,,,y.Activate(4)
,else
,,mes F"{varModelV} not found"
,,goto errorHere