¥»©«³Ì«á¥Ñ chiang0320 ©ó 2016-11-7 00:04 ½s¿è
Union(1).zip (12.98 KB)
¨âÓ°ÝÃD½Ð±Ð¦Ñ®v±Ð¾É¡AÁÂÁÂ!
¥H¤Uvbaµ{¦¡½X¡A±ø¥ó--->±N¤j©ó30ªºÀx¦s®æ¿ï¨ú
1. «ç»òק令¿ï¨ú "¾ã¦C(rows) "
2. ¦pªG±ø¥ó§ï¦¨¤p©ó2ªºÀx¦s®æ¿ï¨ú¡A·|Åã¥Ü¿ù»~¡A "½Ð°Ý«ç»òק令¡A¦pªG¨S¦³¦b±ø¥ó¤ºªº¸ê®Æ«h¸õ¹L"
Public Sub QQQ()
Dim i As Long, Target As Range
For i = 2 To 11
If Cells(i, "B") > 30 Then
If Target Is Nothing Then
Set Target = Cells(i, "B")
Else
Set Target = Union(Target, Cells(i, "B"))
End If
End If
Next
Target.Select
End Sub |