Hi All
I have an invoice which I format using VBA, in this I have a .Find code that finds the header line so it can delete all the other crap.
The issue I have is that the people who provide this for me keep changing the working in the header, so I was thinking, is there away to have a .Find code but have it check through mulitple possible strings?
So something like this:
.Find("FOB PRICE") or .Find("UNIT PRICE") or .Find("PRS") or .Find("TTL") etc etc
So it goes through this list of key words looking for each one in turn? If it finds one then it stops there?
Thanks in advance