Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Using Office 2003 and Windows XP;
Picture 3 columns of values from 167 to 212; each value incrementing by 3. Thus: 167 167 167 170 170 170 173 173 173 176 176 176 179 179 179 .... See above, except that each column goes up to 212; this gives a spread or range of 16 values in each column. I need a macro that will generate a list of these values in every possible combination with one another (16 * 16 * 16 = 4096 combinations - I think). Anyone got a clue how to do this, or has someone out there got some VBA code they can post? Thanks so much in advance for your assistance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How generate new list in another worksheet from existing list? | Excel Worksheet Functions | |||
How to get all number combination from a list | Excel Programming | |||
Need to generate random values from a list | Excel Discussion (Misc queries) | |||
How do I generate a list from a range of values | Excel Worksheet Functions | |||
Calling (Function?) from Userform_Initialize to generate list of unique values for Combo box | Excel Programming |