Delete duplicate cells?

Tina;
You have two options:
1. On the ribbon, find the Delete Duplicates Icon and follow the wizard.
2. Insert the following macro

Please Login or Register  to view this content.

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

1. Press Alt-F8 to open the macro list
2. Select a macro in the list
3. Click the Run button

Make sure that you don't have any cells on your spreadsheet open in Edit mode and try again.

Ok. Looks like you don't have the Developer Tab on your ribbon visible. On the file tab, click on Options. On the Popular selection, look for the "Show Developer Tab in the Ribbon" and click on the checkbox. Save and Close the options.

Now on the Developer Tab on the far left is an Icon "Visual Basic". Click on it and it should open the VBE.

Appears that your IT dept may have disabled all Visual Basic Application parts of your program. I am going to post this in another section of the forum for others to look at and see if they have seen this before and maybe have a solution. Check with your IT department and see if this is something they did.

I just found this link that may apply in your case:

http://www.excelforum.com/excel-prog...-disabled.html

The reason is that the VBA - Macro Part is not installed in that OP's Machine.

Upto 2003 the office macros (VBA) are getting installed in default, but in the later versions of 2003 microsoft made it as Optional at the time of installing the Ms-Office.

A simple method to know whether the macros is installed or not:-

View>>Macros>>Select the Drop Down>>If everything is showing as disabled then surely no VBA part installed at the time of installation.

Re-installing the Office by way of selecting the VBA part will be the only solution in this case

Can you upload a sample workbook to test. I have use that VBA for years and it has always worked for me. I would like to test with your data.