+ Reply to Thread
Results 1 to 1 of 1

Draw routine

  1. #1
    Registered User
    Join Date
    03-13-2013
    Location
    BH, Brazil
    MS-Off Ver
    Excel 360 Mac
    Posts
    10

    Draw routine

    Hi! Learning VBA just to create this table but my knowledge grows slowly so I ask for help

    It is basically a draw. I'm using a XMatch function to generate random numbers and search a lookup array (in my example the numbers on the array are consecutive but that might no be the case always, that's why I have "redundant" numbers on VBA). When drawing for each cell (green ones are just examples), the code should compare the XMatch result with all cells on the rows above it AND to some cells on the columns on the left (on this example I used 10, but that number should be easily changeable).

    The only known values are rows 30 and 31 that are copied from rows 32 and 33 from the column on the left, every other value should be drawn based on this criteria.

    If this is successful, I will learn how that implementation is done and create a few more conditions to accept the XMatch (say, lines 23-26 should be drawn from a specific subset of cards, etc)

    Thanks
    Attached Files Attached Files

+ 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] Excel 2016 Sort routine issue - recording macro has sheet name in sort routine
    By pongmeister in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-05-2016, 02:45 PM
  2. [SOLVED] naming a routine and calling it in another routine - not a loop
    By HeyInKy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-16-2015, 11:54 AM
  3. Pass a variable from one sub-routine to another sub-routine
    By gowtham_pec in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-01-2013, 07:07 PM
  4. Sub Routine Name
    By stoney1977 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-19-2011, 04:52 PM
  5. Why won't this routine run?
    By cmcgath in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-17-2009, 03:41 PM
  6. This routine just keeps on going! Why?
    By LFCFan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-20-2006, 11:18 AM
  7. [SOLVED] VBA routine (101)
    By Ray in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-26-2005, 03: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