Posted to microsoft.public.excel.programming

Carol[_7_] Carol[_7_] is offline

external usenet poster

Posts: 1

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to copy values then delete row for entire sheet	Pyrotoy	New Users to Excel	18	December 9th 08 12:43 AM
Select and delete entire row Excel VBA macro	RL	Excel Programming	2	February 26th 08 02:20 PM
Macro - delete entire row which contain a specific text	Dileep Chandran	Excel Worksheet Functions	1	December 6th 06 01:08 PM
Help! with Macro - delete entire row	Rashid[_2_]	Excel Programming	3	March 4th 06 09:14 PM
macro to delete entire rows when column A is blank ...a quick macro	vikram	Excel Programming	4	May 3rd 04 08:45 PM

All times are GMT +1. The time now is 02:00 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us