Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a problem I can't seem to find a solution to, so hopefully
someone has some ideas... I found a problem similar to mine with a solution that gets me part of the way there, see the below link: http://www.excelforum.com/excel-prog...excel-vba.html I would like to be able to take table, such as... Variable Variable 1(Shirt size) [small;medium;large;...;Y] Variable 2(shirt color)[blue;green;red;....;Z] .... variable X (...) When the number of variables is fixed, the solution seems to just be the correct number of for...next loops. However, when the number of variables is undefined; I run into a problem. I need the code to be flexible enough to adjust for the number of variables. I know I can build an array to pick up the number of variables, and also the number of selections within each variable, but once I've got that, I'm stuck; since the only option I can think of is the hard- coded for/next loops. Ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
counting the number of two different variables | Excel Discussion (Misc queries) | |||
How to make a public function procedure with undefined number of r | Excel Programming | |||
How to go "X" number of days out from a undefined date? | Excel Discussion (Misc queries) | |||
Linking Worksheets in an undefined number of Workbooks | Excel Discussion (Misc queries) | |||
How do I add the number of variables? | Excel Discussion (Misc queries) |