Hiya again.
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.
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.