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.
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.
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.