Discontiguous Column Selection

I have a macro that boils out the differences between the cells in Column A and Column B. I've had this one for years. Not posting it because the existing code isn't the issue.

This morning I saw two macros at http://www.excelfox.com/forum/f22/hi...d-column-2047/ that also work on columns A and B, which reminded me that there's a change I want to make to my original macro.

What I'm looking for is a way to adapt either my original macro, or the two at the link above, to handle 2 separated columns that I've selected, so I'm limited to not only A:B, but instead can compare C with F or G with H.

I think all I need to do is set a variable to each column (ie Col1 would be "C", Col2 would be "F"). Where I'm confused is, if I have two different columns selected, how do I tell VBA that "the column on the left is Col1, the column on the right is Col2"? Any help would be appreciated.

I could go that route, but that would require my user to read InputBox1, select Col1 range, then click to accept, then read InputBox2, select Col2 range, then click to accept. I was hoping there would be a way to do it with their already-selected columns. For instance, if their selection at the beginning of the Macro ISN'T two column, go the inputbox way. If it IS 2 columns, then compare the left one to the right one. That's where I'm getting stuck.

Thanks Mr. Shorty, that really gets me started. By counting columns I can ensure 2 and only 2 columns are selected. With Areas, I can differentiate between Areas(1) and Areas(2), unless they're adjacent.

JosephP, I appreciate the intersect code, but here's where I'm still struggling; using the Intersect configuration, I can verify that the two columns are adjacent, but that leads me back to how do I call each column by a unique name? In other words, the user won't always pick A:B. Sometimes he'll pick U:V, or F:G. Once we get into the macro proper we do different functions with Col1 vs Col2, so using Intersect how do I differentiate between Col1 and Col2 when they're adjacent?

Please Login or Register  to view this content.

Thanks so much for the column selection code; I'll use that time and again, I'm sure.

I've had a rethink on my original code (Original and Updated are both pasted below). My original only worked with A and B, and wrote the results in C, D and E, I wanted to expand the capability to compare ANY two columns, but on reflection I don't necessarily want to change the sheet those two columns come from, so my updated macro copies the two columns to a Comparison sheet and does the comparison there, so I'm back to working with A:E. I think this tweak could be easily put into either or both of the macros I listed at the start of this thread as well if anybody wants to tackle those.

Thanks for all the help, and I hope someone else enjoys the updated code.

Please Login or Register  to view this content.

Please Login or Register  to view this content.