+ Reply to Thread
Results 1 to 5 of 5

InputBox String Conversion

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    07-01-2005
    Posts
    103

    InputBox String Conversion

    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.


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

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644
    Why do you need to find where the range starts?

    Can't you just loop through it?
    For Each c in myRange ' loop through each cell in the range
        ' code for working with each cell
    Next c

  3. #3
    Forum Contributor
    Join Date
    07-01-2005
    Posts
    103
    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

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644
    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.

  5. #5
    Forum Contributor
    Join Date
    07-01-2005
    Posts
    103
    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?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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