Results 1 to 12 of 12

Identify redundant data, but choose the latest date and delete the other one

Threaded View

  1. #11
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,834

    Re: Identify redundant data, but choose the latest date and delete the other one

    That's correct and should work.

    Any cell within the data range will get the proper range.

    e.g

    Range("a10").CurrentRegion, Range("B10").CurrentRegion, Range("c12").CurrentRegion
    should get the same data range.
    Last edited by Cutter; 07-24-2012 at 09:57 AM. Reason: Added code tags

Thread Information

Users Browsing this Thread

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

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