+ Reply to Thread
Results 1 to 2 of 2

Comparing values & delete

  1. #1
    Registered User
    Join Date
    10-02-2008
    Location
    Salt Lake
    Posts
    3

    Comparing values & delete

    I am trying to delete row by comparing values in Column A. I want to delete duplicate items. So if Row 2 Column A is equal to Row 1 Column A I want to delete it. This is what I have but I'm missing something.

    Please Login or Register  to view this content.
    Last edited by dragmac; 10-13-2008 at 10:51 AM.

  2. #2
    Forum Contributor
    Join Date
    09-04-2006
    Location
    Yorkshire, England
    Posts
    267
    Heres a simple method, just replace the msgboxs with your delete row code.

    Please Login or Register  to view this content.
    JR
    Versions
    Mac OS X 'Leopard'
    Mac MS Office Excel 2004
    Windows XP
    MS Excel 2002
    MS Excel 2003

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. comparing values
    By hanyou.lin in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-14-2008, 03:44 PM
  2. Find Values, Delete and Move Left
    By rkeane7 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-01-2008, 09:34 AM
  3. Comparing Columns and Deleting values
    By oneblueaugust in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-06-2007, 02:43 PM
  4. Auto Delete Repeating Values
    By KHaberstroh in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-19-2007, 05:50 AM
  5. Comparing two values and highlighting using color
    By ramki in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-15-2006, 12:19 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1