Speed up FindAll()

[Paul Meems]

I have two workbooks. A large one with several sheets and around 1500 rows. And a smaller one with around 50 rows.

I loop through the smaller one and call FindAll() for each row on two sheets.

This takes around 5 min.

I wonder if I can improve the speed.

[Abirami Varadharajan]

Hi Paul, 

  

Greetings from Syncfusion. 

  

We are unable to reproduce the issue while invoking FindAll() for each row upto 50 rows. We are sharing the sample created as per your scenario for your reference which can be downloaded from following link. 

  

Sample Link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/Find-60823791.zip  

  

It is recommended to use FindAll() for worksheet  to find the specific word in entire worksheet. If the issue still persist, kindly share us issue reproducing sample to validate further from our side. 

  

Regards, 

Abirami 

[Paul Meems]

I understand no special settings are available/

The slowness is most likely due to my sheet.

This issue can be closed.

[Abirami Varadharajan]

Hi Paul, 

Thank you for updating us. 

Please let us know if you need any further assistance. 

Regards, 

Abirami