Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select Case
Is there a way the following code can be written where the places where 8 and
10 would depend on a cell value? If the cell value = 424 then dim myCase as string myCase = range("A1").value for i = 28 to myCase Select Case i case 28, 127, 226, 325, myCase or if the cell value = 10 then case 28, 127, 226, 325, 424, myCase the increment of the case is 99 End Select Next |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select Case
'where 8 and 10 would depend on a cell value' Don't really understand what
you mean here. However, if steps are always 99 then why not use something like this:- For i = 28 To myCase Step 99 'your code in here including test for cell value Next -- Regards, OssieMac "jnf40" wrote: Is there a way the following code can be written where the places where 8 and 10 would depend on a cell value? If the cell value = 424 then dim myCase as string myCase = range("A1").value for i = 28 to myCase Select Case i case 28, 127, 226, 325, myCase or if the cell value = 10 then case 28, 127, 226, 325, 424, myCase the increment of the case is 99 End Select Next |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Case without Select Case error problem | Excel Discussion (Misc queries) | |||
Select Case | Excel Programming | |||
End Select without Select Case, Block If without End If errors | Excel Programming | |||
Need help on Select Case | Excel Worksheet Functions |