match2

  1. S

    IF Statement Not Working - Need 2nd Pair of Eyes

    I cannot figure out why my IF statement won't populate the matches in the highlighted cells from the image above. Any thoughts? Do Until Range("AQ" & row).Formula = "" match1 = "" match2 = "" match3 = "" code1 = Range("AQ" & row).Value code2 = Range("AR" & row).Value code3 = Range("AS" &...
  2. S

    RANGE .VALUE & .FORMULAR1C1 Will Not Accept - 1004 'Range of Object Error'

    Good Morning Experts, I have used the following in many of the macros I have built, and for some reason, this particular procedure doesn't like my code and I cannot figure out why. This time I've used a different looping method and added multiple variables. I've highlighted the errors I...
  3. S

    CODE DOES NOT RUN - No Errors, just doesn't run

    Hi Guys, I worked on a code over the weekend on my computer at home, which has Excel 2016. This code worked over the weekend on my computer at home, but I haven't been able to get it to run on my work computer (Excel 2013). I'm not sure the differences in Excel builds are the problem... The...
  4. A

    Hanging Process?

    Hello, I have built an inventory program for our pharmacy at work. I have little to no experience with coding and I kind of pieced it together and it is starting to come together. The issue I am currently having is periodically the program will stop working, in that the enter button not longer...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top