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.
|