Home > Software engineering >  Want to find the coordinates of the corresponding value in EXCEL, but where is write wrong? Please c
Want to find the coordinates of the corresponding value in EXCEL, but where is write wrong? Please c

Time:09-19



 X=xlsApp. Sheet (" Level "). The Range (" A1: AE1 "). Cells. The Find (" levels. Appearance 1. The Caption "). The Column 
'Level here. Come on stage 1. Caption as a variable, want to find in the EXCEL Level page to sign corresponding to the value of X coordinates

Y=xlsApp. Sheet (" Level "). The Range (" A2: A61 ") Cells. The Find (" checkpoint. ChapterLabel. The Caption "). The Row
'here levels. ChapterLabel. Caption as a variable, want to find in the EXCEL Level page signed corresponds to the value of Y coordinates



But the runtime tip
Error: 91
Object variables or variable is not set with block

Ask where is write wrong?

CodePudding user response:

The last post first married
  • Related