+ Reply to Thread
Results 1 to 2 of 2

"If" help: checking multiple variable cell range against another range

  1. #1
    Registered User
    Join Date
    11-11-2015
    Location
    Chile
    MS-Off Ver
    2010
    Posts
    2

    "If" help: checking multiple variable cell range against another range

    Hello everyone,

    I've been trying to find a solution to this on the internet but to no success.

    My issue is: I need to compare 2 Cell Ranges within an If statement, every element of the first range has to be lower of the corresponding element of the second range, so that I could execute a series of commands, all of this would be within a For, and on each iteration, the size and position of the ranges would change based on an external value.

    For example: Range A1:A10 would be filled with 10's, Range B1:B10 would be filled with random numbers I get on previous iterations, then I need to compare A1:A2 with B1:B2 so that B1<A1 and B2<A2, if that criteria is met, I execute some commands AND B1 and B2 both get +1, then on the next iteration I would compare A1:A4 with B1:B4, repeat, then on the next one A2:A4 vs B2:B4, etc, size and position are determined by values on another column

  2. #2
    Registered User
    Join Date
    11-11-2015
    Location
    Chile
    MS-Off Ver
    2010
    Posts
    2

    Re: "If" help: checking multiple variable cell range against another range

    Bumping Up

+ 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. [SOLVED] Size a range from the size of another in VBA variable
    By jayherring86 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-09-2015, 09:17 AM
  2. [SOLVED] Assigning a 2D Array to a bigger size range results in "#N/A" in the uncovered elements
    By TopXorGuy in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-24-2013, 10:45 AM
  3. Replies: 0
    Last Post: 01-09-2013, 06:52 PM
  4. "Move and Size with Cell" sometimes doesn't work with VBA created Buttons
    By daveNYC in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-29-2012, 03:27 PM
  5. Replies: 3
    Last Post: 06-04-2011, 10:56 AM
  6. Error msgs: "Object varible or with block variable not set"; "subscript out of range"
    By menyanthe in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-26-2009, 04:58 PM
  7. use variable in Workbooks("book1").Worksheets("sheet1").Range("a1"
    By Luc in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-28-2005, 04:05 PM

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