- ©«¤l
- 3
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 4
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- 1.0
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2011-1-31
- ³Ì«áµn¿ý
- 2011-2-5
|
[µo°Ý] ½Ð°Ý¦p¦ó§ó§ï³o¤@Órangeªº¼ÆÈ
¥»©«³Ì«á¥Ñ joseph2003 ©ó 2011-1-31 22:08 ½s¿è
Sub Find_Num()
For Each Found_Num In Worksheets(2).Range("A1:F3")
For Each Data In Worksheets(1).Range("A1:AI20")
If Data.Value = Found_Num Then
Data.Interior.ColorIndex = 3
End If
Next Data
Next Found_Num
End Sub
--------------------------------------------------------------------------------------------------
¦pªGn§ï¦¨
Worksheets(2).Range("A1:F1")对应Worksheets(1).Range("A1:AI5")
Worksheets(2).Range("A2:F2")对应Worksheets(1).Range("A6:AI10")
Worksheets(2).Range("A3:F3")对应Worksheets(1).Range("A11:AI15")
.........
.........
¥H¦¹Ãþ±À
¤]´N¬O»¡sheets(2)¨C¹j¤¦C¥u©â¨úsheet(1)¤@¦Cªº¸Ü
n¦p¦ó§ï¼g©O
Book1.rar (7.72 KB)
Áٽаª¤âÀ°À°¦£
·P¿E¤£ºÉ |
|