icolcount

  1. N

    Unique Values Macro

    Hi, I have code that I use as a personal macro on my ribbon that lets you highlight a list of cells and it pastes this to another tab and removes duplicates so I can get a unique count: Sub List_Unique_Values() 'Create a list of unique values from the selected column Dim rSelection As Range...
  2. A

    Search delete copy-N-paste to new sheet not working....

    Hello, I have code that when I select column B the script looks through column B for duplicate values among unique numerical strings of data. When a duplicate is located the code should delete the entire row without scrambling or re-sorting the data set and copy the final result of the entire...
  3. L

    Add check boxes to active sheet using VBA

    Hi All I'm not sure this is possible but I came across some VBA code that allowed you to add check boxes to an active sheet based on the selection made, unfortunately the check box name remains the default "Check Box #" convention, I have successfully modified the code to add the correct...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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