Is is possible to set a search area on a different selection/sheet/workbook without leaving the current selection or leave the current sheet?
I want to use it in conjunction with the
Thanks![]()
Please Login or Register to view this content.
Is is possible to set a search area on a different selection/sheet/workbook without leaving the current selection or leave the current sheet?
I want to use it in conjunction with the
Thanks![]()
Please Login or Register to view this content.
Yes, you can. Check the attached code for a demonstration
![]()
Please Login or Register to view this content.
If you like my contribution click the star icon!
Thanks Ollie B
Your answer did give me good guidance. The parameters in my original line does not work with the "rngSearch" spesification.
Thanks again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks