+ Reply to Thread
Results 1 to 3 of 3

[Solved] Problem with highlighting differences between two worksheets

  1. #1
    Registered User
    Join Date
    11-28-2012
    Location
    Florida
    MS-Off Ver
    Excel 2010
    Posts
    2

    [Solved] Problem with highlighting differences between two worksheets

    Hey everyone,

    New to this forum and to VBA in general. I am trying to compare data in two worksheets in the same workbook and highlight the differences. The worksheets are identically formated. Here is what I have so far:

    Please Login or Register  to view this content.
    Even though I have the rows set to (6, 27) and the columns at (2, 13) it is only highlighting cell A1 as there are different values in the cells. Why isn't it only highlighting the different values in cells B6 through M27?

    Any help would be appreciated!

    moderators note: code tags added for you - this time
    Last edited by gilde; 11-28-2012 at 04:02 PM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Problem with highlighting differences between two worksheets

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    11-28-2012
    Location
    Florida
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Problem with highlighting differences between two worksheets

    Sorry, thanks for heads up!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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