I have this XL file with many worksheets.
I want to find the a cell's value. Simple as that.
The xl function result is false and the returned value
from Val_PDBase var is Year.
Strange because the value to look for XLFind is located in All columns sheet, row 1 col 21.
Wonder what is the problem.
Here's the link to the file
https://u.pcloud.link/publink/show?code ... lfHHA7TdXV
Here's the sniplet code
Code: Select all
XLOpen>%USERDOCUMENTS_DIR%\mybook.xls,0,xlBook
Let>val_1=Basic Coverage Guaranteed Life Insurance Amount
XLFind>%xlBook%,All Columns,%val_1%,isFound
XLGetSelectedCell>%xlBook%,Val_PDBase,Row_PDBase,Col_PDBase
XLQuit>xlBook
![Very Happy :D](./images/smilies/icon_biggrin.gif)