+ Reply to Thread
Results 1 to 4 of 4

Cell Comparison Question

  1. #1
    Registered User
    Join Date
    04-04-2012
    Location
    LONDON
    MS-Off Ver
    Excel 2010
    Posts
    3

    Cell Comparison Question

    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!

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,465

    Re: Cell Comparison Question

    You could evaluate it with Like operator with the wild card or Find method with the partial match.

  3. #3
    Registered User
    Join Date
    04-04-2012
    Location
    LONDON
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Cell Comparison Question

    Thank you very much, I will try those suggestions.

  4. #4
    Registered User
    Join Date
    04-04-2012
    Location
    LONDON
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Cell Comparison Question

    I am happy to report that the Find with partial match method worked. Thank you one again.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1