nachiketdp
Board Regular
- Joined
- Jan 31, 2007
- Messages
- 53
Hi,
I wanted to encode finding a particular string within the whole workbook. I tried to record it using macro recorder but I didn't get the desired code i.e. whatever code I got finds it only within the worksheet.
I tried searching it on excel vba help but it seems that the find mehod is restricted at worksheet level.
Actually this seems a little tough to digest as there doesn't seems to be any reason for disabling any option in macros which is available while doing it manually.
Any kind of inputs from you to help me find within workbook using macro will be highly appreciated!
Thanks,
Nachiket Pendharkar.
I wanted to encode finding a particular string within the whole workbook. I tried to record it using macro recorder but I didn't get the desired code i.e. whatever code I got finds it only within the worksheet.
I tried searching it on excel vba help but it seems that the find mehod is restricted at worksheet level.
Actually this seems a little tough to digest as there doesn't seems to be any reason for disabling any option in macros which is available while doing it manually.
Any kind of inputs from you to help me find within workbook using macro will be highly appreciated!
Thanks,
Nachiket Pendharkar.