• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. R

    VBA Search Help

    It was still taking forever...so I looked at it again and tried something that fixed the speed issue. The data being imported from SharePoint was another macro step that I was going to call with this one. So I tried converting the table to range and then running the query and for some reason...
  2. R

    VBA Search Help

    There are no blanks. It is because there are fewer diagnosis codes than procedure codes. Eventually it will be column A (ID will be ignored), Column B (DX codes), Column C (procedure codes), Column D (Drug names) Col A Col B Col C Col D 1 4120 89123 Asprin 2...
  3. R

    VBA Search Help

    Luke- Thanks for the quick reply. That makes sense...but something is causing it to stall out. I've never had to search with a range this large, so it could be that it's just too much data. The previous step will be to import a SharePoint list that ends up formatted as a table. There are 834...
  4. R

    VBA Search Help

    Ok. So I might be going about this the wrong way, but here's what I have working so far. a) I have found and tweaked a macro to search a particular column for particular medical diagnosis codes and then highlight the whole row if the value is in the array. This works great and does what I...
Back
Top