Posted 8 September 2017, 2:25 pm EST
"Ram" + "*",
spread.ActiveSheet.RowCount - 1,
spread.ActiveSheet.ActiveColumnIndex = colindex;
spread.ActiveSheet.ActiveRowIndex = rowindex;
1-Suppose i have two rows
when we search with above method its find "Tuka Ram" but we want "Ram Nath".
We want to search only start value not in between of the sentence.
2- We have 9000 row in our Item table.
when we search data of the active column, it takes 1-2 minutes to reach target cell.
In previous version of VB compatible spread takes only 2-5 seconds.
Please tell me how we increase the search speed.
Thanks and Regards,
Ram Nath Verma