Results 1 to 18 of 18

Highlighting Duplicates across the work book in different ranges - with attachment

Threaded View

  1. #15
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: Highlighting Duplicates across the work book in different ranges - with attachment

    Not sure why the blank cells were highlighted with red but when I deleted them the red color disappeared.
    Also tweaked the code in case if you input the numbers for the company name which is not likely to be case.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA Code for populating cells from one Work Book A to another Work Book with condition
    By ray.kanata in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 06-22-2015, 03:46 PM
  2. check for duplicates in the whole work book
    By Megatronixs in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-02-2014, 06:44 PM
  3. [SOLVED] Highlighting duplicates between 2 ranges
    By Nigel in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-13-2013, 01:52 AM
  4. Linking specific Excel ranges within a work book into a Word Document
    By singerbatfink in forum Word Formatting & General
    Replies: 2
    Last Post: 01-21-2011, 05:13 AM
  5. Work Book as an Attachment
    By suryaprasad in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 03-31-2009, 02:04 AM
  6. [SOLVED] Locate duplicates in a work book by using conditional formatting
    By Pchris in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-03-2006, 02:25 AM
  7. Locate duplicates in a work book by using conditional formatting
    By Pchris in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-03-2006, 02:00 AM

Tags for this Thread

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