PureBasic Forums - English

I need to find whole word. So the problem is to set additional parameters to Find statement to look only whole words.

I tried doing such thing:

excelFileRow = ExcelObject\GetIntegerProperty("ActiveSheet\Columns(4)\Find('value', '$D$4', -4123, 1, 1, 1, 1, 0, 0)\Row")

But no luck...

found ...

Can please someone give an example on how to search for some value in excel and return row number?

I have working pice of code here:

excelFileRow = ExcelObject\GetIntegerProperty("ActiveSheet\Columns(4)\Find('value')\Row")

that is looking for "value" in column 4 but it can return rows that ...

Can someone please help to fetch description field from user object? Due to its multivalued nature it's not clear how to fetch it.


Thank you!