Find The Same Number on another workbook

[realniceguy5000]

Hi,

I'm trying to Find numbers that are in one col in one workbook that might be in another workbook. Here is the script im trying to use.

However after it does one pass I get an object variable or with block variable not set.

Can someone advise what may be wrong?

Here is my script:

Thank You, Mike

Please Login or Register  to view this content.

[barryleajo]

Mike
The loop is working through cells in wb.Sheets(1) and activates once OK - this sheet has the focus
Then sheet wbAudit gets 'activated' within the loop - this then has the focus
Shouldn't wb.Sheets(1) get reset to execute the next cycle of the loop?
barry

[realniceguy5000]

Mike
The loop is working through cells in wb.Sheets(1) and activates once OK - this sheet has the focus
Then sheet wbAudit gets 'activated' within the loop - this then has the focus
Shouldn't wb.Sheets(1) get reset to execute the next cycle of the loop?
barry

Well the loop worked fine as when I step through it A is a new number, I did change the script to this and now it's working.

Thank You, Mike

Please Login or Register  to view this content.

[barryleajo]

Well done Mike
Glad you're sorted
barry