- ©«¤l
- 2035
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 2031
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-3-22
- ³Ì«áµn¿ý
- 2024-2-1
|
¦^´_ 7# man65boy
®M¥Î GBKEE ¤j¤jªºµ{¦¡½X¡A¨Ã¥[¤W- If Sh.Range("a4") <> "" Then
- .
- .
- End If
½Æ»s¥N½X ¨Ó¹LÂoªÅ¥Õ¤º®eªºªí³æ¡G- Sub Ex()
- Dim Rng(1 To 12) As Range, Sh As Worksheet
- For Each Sh In Sheets ' Sheets ª«¥ó: ¬¡¶Ã¯Sheetªºª«¥ó¶°¦X
- If Sh.Range("a4") <> "" Then
- Set Rng(1) = Sh.Cells.Find(Sh.Range("a4"), Sh.Range("a4")) ' [ª««~½s¸¹ ]©Ò¦b¦C:¬°©Ò¦³¤u§@ªíªí³æ¤Wªº¦@³qÂI
- If Not Rng(1) Is Nothing Then '¤u§@ªí¤W¦³´M§ä¨ì [ª««~½s¸¹ ]
- Set Rng(2) = Nothing
- Do
- If Rng(2) Is Nothing Then
- Set Rng(2) = Rng(1).Offset(-3).Resize(4).EntireRow '[ª««~½s¸¹ ]©Ò¦b¦C ,©¹¤W4¦CÀx¦s®æªº¾ã¦C
- Else
- Set Rng(2) = Union(Rng(2), Rng(1).Offset(-3).Resize(4).EntireRow) ''¾ã¦X:[ª««~½s¸¹ ]©Ò¦b¦C ,©¹¤W4¦CÀx¦s®æªº¾ã¦C
- End If
- Set Rng(1) = Sh.Cells.FindNext(Rng(1))
- Loop Until Rng(1).Address(0, 0) = "A4"
- If Not Rng(2) Is Nothing Then Rng(2).Delete '§R°£
- End If
- End If
- Next
- End Sub
½Æ»s¥N½X |
|