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

Extract data to new sheet 4
Macro to ransfer data 5
Delete rows takes forever 4
macro to delete duplicate rows using Filter 2
Streamlining macro created by macro recorder 3
Filter based on named range cell - debug help required 3
Sort Range and Sum/Delete Duplicate Rows 9
can't paste from clipboard in my macro 1

Top