object error

[braven]

i have error in LINE
.Cells(j,"A").Value = Name - OBEJCT ERROR
COULD YOU HELP ME WHY IT IS COMING?

j = 2

Do
For i = 8 To 22
Name = Trim(Sess.Screen.GetString(i, 12, 10))
Account = Trim(Sess.Screen.GetString(i, 34, 19))
j = j + 1
With xl_wb.Worksheets("EQPSC")
.Cells(j,"A").Value = Name
.Cells(j,"B").Value = Account
End With

Next i

 

[GhostWolf]

Could it be that "Name" is a reserved word? You could change it to "strName" and test to see...