help with finding values in another workbook

[Luis939]

I have this code

Set rCell = Workbooks("NortheastArea2003.xls&quot.ActiveSheet.Range("B:B&quot.Find(what:=ActiveCell, LookAt:=xlPart, SearchOrder:=xlColumns)

this searches NortheastArea2003 for the contents of the activecell in the active workbook

then when i find the activecell, i want to conduct another find in NortheastArea2003, not the activeworkbook, how do i do that? i tried

Cells.Find(what:="AT&T", After:=rCell, LookAt:=xlWhole, SearchOrder:=xlByRows).Activate

I dont know why its not working, doesn't rcell already contain the range for where to start looking?? thanks!

 

[SBendBuckeye]

I believe you need to prefix it with
Workbooks("NortheastArea2003.xls&quot. just like the first one to ensure that the proper workbook is being searched.

Good LucK!