Hello,

Could someone please help me agian. I'm trying to get a Macro that wil
search through my spread sheet and when it finds a dublicated tex
entry in column B it will delete everything from A to E


__A___B___C___D___E
1.| T | P | A | C | W
2.| B | P | S | A | J <--- Dublicate P found Deleting A to E
3.| A | Y | N | L | Q
4.| D | E | X | E | I
5.| V | N | Z | F | U

And so on...

Thanks,
Bria

--
Message posted from http://www.ExcelForum.com