How to find the row number if the particular value inthat row is given for example if value 24456 is given as input how to fing it is placed in C4 row
C4 = tablename.row(24456).item(column).tostring ?
Hope it helps
Its easier with invoke VBA, i wrote an example for you here:
Forum_.zip (8.9 KB)
you just give it the value, it will use the excel search and find function to get the value and it will return the position where the value is stored, for example C15
Unzip it and run it, for now its searching for 120 change that value, play around and let me know if it helps you.