+ Reply to Thread
Results 1 to 5 of 5

Modifying Existing Code + Find Range Differences

  1. #1
    Registered User
    Join Date
    11-29-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    49

    Modifying Existing Code + Find Range Differences

    I have a bit of code that checks the values in 2 ranges for differences, and then prints (in a cell range) the differences between the 2 ranges.
    I would like to modify this a little, instead of having the columns hard coded in the module, I would like the user to be able to select the ranges they would like to compare.

    Here is what I have for code:

    Please Login or Register  to view this content.
    I found this code here:
    HTML Code: 
    https://stackoverflow.com/questions/19567060/fast-compare-method-of-2-columns
    Posted by "crazynut"

  2. #2
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    7,443

    Re: Modifying Existing Code + Find Range Differences

    Hi

    I think that the easiest way to do this is to select one range before running the Macro.

    Then use a input box to enter the address of the First Cell in the second Range.

    What do you think?
    Please Avoid Joining My List Of Blocked Users by:

    Saying Please and Thank you.

    Making requests not demands.

    Checking back on your post. I will not edit any post after 4 days.

    Marking threads as closed once your issue is resolved. How? The tools at the top

    Any reputation (*) points appreciated. None of us gets paid here.

    If you found someone's input useful, please take a second to click the * at the bottom left to let them know

  3. #3
    Registered User
    Join Date
    11-29-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    49

    Re: Modifying Existing Code + Find Range Differences

    I suppose I was thinking that:

    Please Login or Register  to view this content.
    Was the route I was going to go down. But wasn't sure if that was the best course of action?

  4. #4
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    7,443

    Re: Modifying Existing Code + Find Range Differences

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    11-29-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    49

    Re: Modifying Existing Code + Find Range Differences

    Couple of questions:

    The input box does not allow me to select the starting point of the second range, I can however type in the start point.
    Also, would't this part of the code need to be updated to reflect the users selection?

    Please Login or Register  to view this content.

+ 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. Modifying existing code to save worksheet
    By Woopwoop in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-26-2015, 08:54 PM
  2. Inserting new columns and modifying existing VBA related code
    By kriminaal in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-06-2015, 05:23 PM
  3. Modifying existing code
    By rhouston08 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-13-2015, 06:03 PM
  4. [SOLVED] Add two more columns, modifying an existing VBA code help.
    By Anka in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 02-17-2013, 01:24 PM
  5. Modifying Existing Code to Check if the entry exists
    By jason_kelly in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-31-2010, 10:39 AM
  6. Modifying existing VBA code to find different file name
    By PittsburghEng in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-03-2010, 03:24 PM
  7. Help modifying existing VBA code
    By camcafe in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-28-2008, 11:02 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