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.
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.
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.