I like this forum as you can tell :P

I have 2 open workbooks. I've picked up the filenames in VB.

One of them is strRemitN

Another one is strStateM

In strRemit i have invoice numbers (OP/I123456) in column A.

in strStateM the invoice numbers are in column C

How would i go around, in VBA, to search for the first invoice number from strRemitN to strStateM, delete the row, then go to the next, all the way to the bottom?

To help with the stuff i've already got... i've worked out the last row.

Dim intLRow as integer

intLRow = Range("A65536").End(xlUp).Row

Can anyone either help me on this or point me in the right direction please?

Thanks.