Question

How to use excel advanced find action to find contents within an entire workbook? It seems like the find action can only perform the find in a specific worksheet. Thanks.

  • 18 January 2022
  • 2 replies
  • 10 views

How to use excel advanced find action to find contents within an entire workbook? It seems like the find action can only perform the find in a specific worksheet. Thanks.

2 replies

Hi @Xiaqi Jiang​ , I think you can accomplish the find across all worksheets, Get worksheet names as list and loop list with find, break after first find, or save each find with worksheet, address to list or dict.

Regards,

Alex

Hi @Alex Salwisz​ , thank you for your suggestion. I used retrieve sheets count to get the number of the worksheets and loop the number of the sheets with the find function. Thank you.

Reply