Modifying Existing Code + Find Range Differences

[jrean042]

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:

Posted by "crazynut"

[mehmetcik]

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?

[jrean042]

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?

[mehmetcik]

Please Login or Register  to view this content.

[jrean042]

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.