Hi,
What I'm trying to do is take a value from one workbook, and search for it in a different workbook which has data spread over 12 worksheets. When it finds the data, I need it to pass the name of the worksheet back to the original workbook. I used macro recorder to get the code for selecting and searching the multiple worksheets, but when I added that into my existing code, I got an error (With block not set?)
Here's what I'm using - can anyone figure out why it won't work?
![]()
Please Login or Register to view this content.
Bookmarks