Excel Single Row Checking

[philipq]

I am getting the below mentioned error code when

Error (RT) in <open ":2991: /4839">Amended Orders AL - VISTA Verification: 0x80020009, Exception occurred.
0x3EC,. <help #IDP_ERR>?


Macro Amended Orders AL - VISTA Verification

Code:

Copy      Help

,es.Activate(2|4 "" "L405 Option Bank.xlsx")
,
,ExcelSheet x.Init(var1 1)
,ARRAY(Excel.Range) c
,Excel.Range r1
,
,;;*******FIND MODEL********
,if x.Find(varModel c 2)
,,r1=c[0].Offset(0 -1)
,,varModelV=r1.Value
,,out F"col={r1.Column} row={r1.Row} value={varModelV}"
,else
,,mes "Model Not Found"
,,goto errorHere
,
,;;*******FIND EXTERIOR COLOUR********
,x.Init("Color" 1)
,if x.Find(varSplitColour[0] c 2)
,,out F"Exterior Colour={varSplitColour[0]}"
,,r1=c[0].Offset(0 -1) ;;*****ISSUE HERE*****
,,varEColourV=r1.Value
,,out F"col={r1.Column} row={r1.Row} value={varEColourV}"
,else
,,mes "Exterior Colour Not Found"
,,goto errorHere
,
,;;*******FIND TRIM*********
,x.Init("Trim" 1)
,if x.Find(varSplitColour[1] c 2)
,,out F"Exterior Colour={varSplitColour[1]}"
,,r1=c[0].Offset(0 -1)
,,varIColourV=r1.Value
,,out F"col={r1.Column} row={r1.Row} value={varIColourV}"
,else
,,varIColourV=varSplitColour[1]