Our vendor send us credit memos that begin with either W, YM,CR or CS I'm
guessing for different material they send have different beginnings. But we
when enter these credit memos in our system they are entered with either CM
or CMM. I wish all of the invoice numbers were the same length but they
aren't this again depends on what the vendor sends us. I thought about doing
a find and replace, but wouldn't work because I'm not sure if YM123 is going
to be CM123 or CMM123 I mean I could research it but that would defeat the
purpose of the macro.


John Bundy wrote:
What is the difference between W,YM,CR,or CS? Are you changing all of these
to CMM? If so then do a find and replace. Are all of your invoice numbers the
same length? If so you can do a search based on the RIGHT(x digits). I just
don't have a clear understanding of what you look for and under what
circumstances.
I'm having an issue with my Macro I have had some help so far but it seems to
be getting more complicated, what it does so far it will look for an invoice
[quoted text clipped - 77 lines]
Next cell1
End Sub

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200703/1