Re: Delete Row meeting a Criteria

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Robert McCurdy (robertwm_at_orcon.net.nz)
Date: 02/29/04

Next message: Together: "Re: How to read multiple text files into excel?"
Previous message: gregork: "Re: My Three Wishes"
In reply to: SRS Man: "Delete Row meeting a Criteria"
Messages sorted by: [ date ] [ thread ]

Date: Sun, 29 Feb 2004 18:43:42 +1300

Hi Man.

Sounds like "DUP" is the result of a formula looking for duplicates.
If so why not change this to 0 (zero) and sort by that column, and then delete the rows with 0?

Regards Robert

"SRS Man" <dthmtlgod@hotmail.com> wrote in message news:#5CHaWH$DHA.3712@tk2msftngp13.phx.gbl...
> Is there a way to delete a row that meets a certain criteria using VBA.
>
> For example, my spreadsheet has 100 rows and I want to delete every row that
> has the word "DUP" in it. They will be spreadout over the 100 rows.
>
> Please let me know.
>
> Thanks
>
>
>

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.593 / Virus Database: 376 - Release Date: 20/02/2004

Next message: Together: "Re: How to read multiple text files into excel?"
Previous message: gregork: "Re: My Three Wishes"
In reply to: SRS Man: "Delete Row meeting a Criteria"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Re: Elementary but surprisingly difficult.
... If you find the right one, you can delete duplicates when the sort notices them. ... dup 9 11 within if ... cells +loop nip; ...
(comp.lang.forth)
Re: Finding repeated words in text documents: what Algorithm ?
... sort and look for adjacent duplicates. ... If word is already in there, you have a dup. ... IN that case use a HashMap and add to the count for every hit. ...
(comp.lang.java.programmer)
Re: duplicates ! duplicates!
... > duplicates are tedious. ... > of these file types. ... > sort them either by folder or by date, ... > that is a dup has the same file name ...
(microsoft.public.windowsxp.general)
Re: duplicates ! duplicates!
... duplicates are tedious. ... An example of the file types ... sort them either by folder or by date, ... that is a dup has the same file name ...
(microsoft.public.windowsxp.general)
Re: to keep you from having difficulties of greater proportions -- Ray (the nice guy)
... what Zero fantasized I said but can't of course cite: ... others make "some sort of claim to be an expert of some sort" are the ... citing his own experiences. ... Which is to say that you said without qualification that I was ...
(misc.writing)