GLYT | Genlyte Group Inc. | 4◄ | 4◄ | 2/4/2005 | $86.98 | $90.04 | 2/11/2005 | 3.52% |
SGTL | Sigmatel, Inc. | €◄ | € | 1/14/2005 | $36.40 | $40.01 | 2/11/2005 | 9.92% |
LDIS | Leadis Technology, Inc. | ∩⌂ | ⌂ | 1/14/2005 | $7.52 | $6.81 | 2/11/2005 | -9.39% |
CEDC | Central European Distr | AC | AC | 1/28/2005 | $32.37 | $33.85 | 2/11/2005 | 4.57% |
SWFT | Swift Transportation | ACHS© | ACH© | 1/7/2005 | $33.53 | $42.59 | 2/11/2005 | 27.02% |
HUBG | Hub Group, Inc. | GQ | GNQ | 1/7/2005 | $31.87 | $32.33 | 3/22/2005 | -45.66% |
WRLD | World Acceptance Co | ABCGX7 | ABCG7 | 1/7/2005 | $35.43 | $35.28 | 3/22/2005 | -30.10% |
RSTI | Rofin-Sinar Tech | GQ | G | 1/7/2005 | $67.56 | $65.81 | 3/22/2005 | -25.01% |
SPF | Standard Pacific Corp. | RSX7 | 7 | 1/7/2005 | $14.41 | $12.53 | 3/22/2005 | -33.56% |
CIG | Companhia Energetica | Y2 | JY | 1/11/2013 | $9.62 | $8.00 | 1/3/2014 | -16.87% |
ALV | Autoliv Inc. | DM2 | 2 | 6/28/2013 | $77.39 | $89.73 | 1/3/2014 | 15.95% |
CRRC | Courier Corporation | O¿ | ¿ | 11/29/2013 | $18.72 | $17.81 | 1/3/2014 | -4.86% |
SMCI | Super Micro Computer | O« | O« | 12/6/2013 | $16.92 | $16.71 | 1/3/2014 | -1.24% |
AHL | Aspen Insurance Hold | DEM | D | 12/6/2013 | $40.83 | $40.54 | 1/3/2014 | -0.71% |
TEX | Terex Corporation | ¥€« | ¥€« | 12/27/2013 | $41.63 | $41.28 | 1/3/2014 | -0.84% |
CBPO | China Biologic Products | JU | S | 5/24/2013 | $26.52 | $28.11 | 1/3/2014 | 6.00% |
SNTS | Santarus, Inc. | €◄ | HL€ | 7/12/2013 | $25.57 | $31.96 | 1/3/2014 | 24.99% |
<tbody>
</tbody>
Range("C3").Select
For combo = 0 To counter
If ActiveCell.Offset(combo, 0).Value = "MQ" Then
Range(ActiveCell.Offset(combo, -2), ActiveCell.Offset(combo, 6)).Select
Selection.Copy
In the "If-Then" statement, I would like to be able to pick out any combination of 2 characters in the sample data set - not just "MQ" which I used as an illustration. For example, I might want to choose the combination "D" & "M", or "A" & "C", or any other combination of two characters.