Delete duplicate rows using macro recorder

D

duugg

Hi all,

After following the instructions on Microsofts site on how to delete
duplicate rows, I ran into a "debug" error.

Here's what I did

1. Control+A to select all cells with data in them.
2. Went to: Data/Filter/Advanced Filter
3. Selected "Filter the list, in place"
4. Checked "Unique Records Only".
5. Selected "OK"
6. Selected Edit/Copy
7. Pressed Delete
8. Selected Edit/Paste

The macro results in the following error...

Title Bar - Microsoft Visual Basic

Run-time error '1004'
Paste method of Worksheet class failed

I noticed that while edit/paste is greyed out, I am able to paste from the
office clipboard. How can I tell Excel to paste from the lastest entry in the
office clipboard and not from the "regular" paste.


Thanks in advance
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy/paste in based on duplicate value in previous row 0
Delete duplicate rows without deleting entire row 1
Macros to delete duplicate entry 1
"Run-time error '1004' 5
how to get a simple macro to paste value 4
Runtime error 438 1
Delete a row that is double clicked 2
Macro only goes to row 43 1

Top