compare range values

  1. A

    Comparing Ranges in VBA

    Hi Firstly, I have to say that I am very new to VBA and have hardly used it before. So I have 3 ranges on a worksheet, with the zeros lining up with each number above: Range 1: 25 50 85 180 350 500 650 850 0 0 0 0 0 0 0 0 Range 2: 25 50 85 180 350 500 650 850 0 0 0...
  2. D

    Compare range values

    Sorry, not sure how to title this problem. I want to test range values. For example, in cell A1, I have a value: 100-500; A2, 501-1000; A3, 1001-1500, and so forth. I want to test each cell (A1 thru Ax...), whether my input value (for example) is within the range. For example, if my input...
  3. M

    Compare rows in VBA

    How do I compare entire rows with each other? I'm trying to write a macro that finds duplicate rows in CurrentRegion and deletes the duplicates but I'm lost with the code: The CurrentRegion has headers and is sorted so the duplicates (if any) should be right ontop of eachother. The problem...
  4. M

    Compare range values in VBA

    How do I compare range values with VBA? I have a customer price table in C3:AQ60 and I'm trying to write a macro to compare if the Cell values in Columns are the same on each Column. There can be up to 20 different values in each column (=up to 20 different ranges within a single column that...

This Week's Hot Topics

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
Top