I have been using Excel VBA to automate some reconciliations and I have been unable to find a way
of using Instr or similar to see if cells in a column, which mainly contain text, also contain an account number
which is located in located in cell A1. The text/text & numeric data is contained in column C. So if A1 was
account number 12345, I would like VBA to register TRUE if any of the cells in column C contained that
same number within the text. So if cell C8, for example, was ABC123456JK I wouild like the code to give a TRUE
result so I could add continue with more code. The account number will change according to the fund being reconciled
so I don't want to hard code it.
Any help would be gratefully recieved!
Bookmarks