Using "FIND" Across Multiple Workbooks

Joined the forum because of this post. It was difficult to find a place that would show how to use the Find method, and actually provide examples.

I do have a question. I've modified the Scenario 4 and am wondering how to incorporate this into use for two separate workbooks. So my UpdateRange is one one workbook, and my DataRange is on another. I can save where the workbooks are, but run into problems in getting aCell = bCell. Any help on ensuring proper syntax for those?

Welcome to the forums JHizzal :wave:

I hardly monitor this thread. The best place to ask questions regarding MS Office is at

http://www.vbforums.com/forumdisplay.php?f=37

I would request a moderator to move this thread and then we can continue it there :)

Can you upload sample workbooks so that I can get my references correct?

Sid

Split from this CodeBank thread into its own thread and moved to Office Development

Thanks for the report Sid! :thumb: