Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Do while loop
I am trying to excercise a loop. I have a series of copy and paste commands
that I want to exercise if cells(i,1) is any of 9 text values (Cos, DL, MRB, Swap, Finishing, DST2,Fin-T,Pre-T,Trap). Is there an easy way to do those either than 9 "IF" statements? Thanks, Mike. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Do while loop
What about a select case statement instead, like so:
Select Case cells(i,1) Case "Cos", "DL", "MRB", "Swap", "Finishing", "DST2", "Fin-T", "Pre-T", "Trap" 'DO PASTING OPERATION HERE End Select "Mike D." wrote: I am trying to excercise a loop. I have a series of copy and paste commands that I want to exercise if cells(i,1) is any of 9 text values (Cos, DL, MRB, Swap, Finishing, DST2,Fin-T,Pre-T,Trap). Is there an easy way to do those either than 9 "IF" statements? Thanks, Mike. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Do while loop
Works like a charm, Mike. Thanks for your help.
"Mike" wrote: What about a select case statement instead, like so: Select Case cells(i,1) Case "Cos", "DL", "MRB", "Swap", "Finishing", "DST2", "Fin-T", "Pre-T", "Trap" 'DO PASTING OPERATION HERE End Select "Mike D." wrote: I am trying to excercise a loop. I have a series of copy and paste commands that I want to exercise if cells(i,1) is any of 9 text values (Cos, DL, MRB, Swap, Finishing, DST2,Fin-T,Pre-T,Trap). Is there an easy way to do those either than 9 "IF" statements? Thanks, Mike. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loop to Filter, Name Sheets. If Blank, Exit Loop | Excel Programming | |||
Naming Worksheets - Loop within a loop issue | Excel Programming | |||
(Complex) Loop within loop to create worksheets | Excel Programming | |||
Advancing outer Loop Based on criteria of inner loop | Excel Programming | |||
Problem adding charts using Do-Loop Until loop | Excel Programming |