Selecting duplicate records

I need to cop开发者_StackOverflow中文版y all the duplicates in a certain sheet, but can't remove. I'm in Excel.

Data samples:

Line__ID___________Value

1_____1____________14

2_____1____________134

3_____2____________15

4_____2____________15

5_____3____________17

6_____3____________16

7_____3____________17

I need to do a CRTL+C in those lines with both duplicated, like lines 3 and 4; and lines 5 and 7.

---

Use the Copy method.

Range("D4:E5").Copy

There. You've copied that range to the clipboard. Assuming that's what mean by "doing a CRTL+C"...

I wonder what exactly you're planning to do once this is in the clipboard.

---

Choose the Advanced Filter from the Data->Filter menu, and check the box for Unique Values. Then cut and paste what you want. Then turn it back off.