InputBox String Conversion

[Paul987]

I am trying to let a user select a range, then search the range against a second range for identical values. I'm having difficulty using the input in the macro, specifically finding where the range begins, and the length for my for/next statements.

I'm pretty new to this, trying to hack this code together from previous posts. Thanks to those authors!
Any help?

[Norie]

Why do you need to find where the range starts?

Can't you just loop through it?

Please Login or Register  to view this content.

[Paul987]

that's why you answer the questions, and I only ask them. Thanks, that worked, it cycles through every cell in the range. Follow up question: the range I'm using is several columns wide, I'm only interested in looking at one column for now. How would I only cycle through column B if the range is A1:D7, for instance?
Thanks

[Norie]

Paul

I don't quite follow.

You are letting the user select the range but then you want to specify the range to work with.

[Paul987]

Well, I want the user to select the range, but that macro will need to run through the range a few times and look at a few columns independently to trigger other if/then statements. Does that make sense?