Thread: Macro to delete entire row
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Carol[_7_] Carol[_7_] is offline
external usenet poster
  
Posts: 1
Default Macro to delete entire row


Hi,

I am using this formula

=IF(COUNTIF($A$6:$A$33100,A6)=1,TRUE,COUNTIF($A$6: A6,A6)=COUNTIF($A$6:$A
$33100,A6))

to highlight the last row item for cells with duplicates. I need to
delete the entire row of all rows that were not highlighted by this
formula.

Hope this makes sense. Any help would be appreciated.

*** Sent via Developersdex http://www.developersdex.com ***
Reply With QuoteReply With Quote