- ©«¤l
- 129
- ¥DÃD
- 25
- ºëµØ
- 0
- ¿n¤À
- 159
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-12-24
- ³Ì«áµn¿ý
- 2022-12-12
|
[µo°Ý] ½Ð°ÝVBA¥i¥H¿z¿ï«á¡A¹ï¨äµ²ªG¦A¶i¦æ¶i¶¥¿z¿ï¶Ü?
¥»©«³Ì«á¥Ñ iceandy6150 ©ó 2021-11-29 23:25 ½s¿è
¤j®a¦n
·Q½Ð°ÝVBA¦³¨S¦³¿ìªk°µ¨ì
¿z¿ï«á¡A¥X¨Óªºµ²ªG¡A¦b°µ¶i¶¥¿z¿ï?
¥H¤U¨Ò¤l
§Ú·Q°µ¨ì¥ý¿z¿ï¥X2021/11/23ªº¶µ¥Ø
¬Ý¬ÝÁ`¦@´XӲŦX (¬õ¦â)
µM«á°w¹ï°Ó«~¥h¶i¦æ"¶i¶¥¿z¿ï" (ºñ¦â) ¤£«½Æ
³Ì«á¬O§â¦UºØ°Ó«~ªºÁ`¼Æ¶q¥[°_¨Ó (ÂŦâ)
¥\¯à»Ý¨D¡G
§Ún°µ¤@Ó¬d¸ß¥\¯à¡A¨Ï¥ÎªÌ³z¹LInputbox¡Aµ¹§Ú¦~¤ë¤é
§Ún±q«Ü¦h«Ü¦h¸ê®Æ¤¤
¥ý¿z¿ï¥X·í¤Ñ¤é´Áªº¸ê®Æ¡AµM«á¤ÀªR·í¤ÑÁ`¦@¦³¦h¤ÖºØÃþªº²£«~¡A¥[Á`¦U²£«~ªº¼Æ¶q
(¦³ÂIÃþ¦ü¼Ï¯Ã¤ÀªR)
¦A½Ð¦U¦ì«ü¾É¡AÁÂÁÂ
´ú¸Õ¿z¿ï¨Ã½Æ»s¯S©w½d³ò.rar (29.08 KB)
(«ö¶s¤T)- Private Sub CommandButton3_Click()
- Dim i
- Dim a
- Dim Sg As Range
- i = Sheets("¤u§@ªí2").Cells(1, 9).Value
- a = Sheets("¤u§@ªí2").Columns(2).End(xlDown).Row
- Dim Rng As Range '¿z¿ïµ²ªG½d³ò
- With Sheets("¤u§@ªí2") '¦b¤u§@ªí2¤¤
- Set Rng = .UsedRange.Range("A1:F" & a) '©Ò¦³¸ê®Æ½d³ò¤¤ªºA1~F©³
- Rng.AutoFilter Field:=1, Criteria1:="2021/11/23"
-
- Set fa = [d2:d65536].SpecialCells(xlCellTypeVisible)(1)
- Set fb = [D65536].End(xlUp)
-
- If fa = "" Then
- MsgBox "¬dµL¸ê®Æ"
- Sheets("¤u§@ªí2").Range("A:E").AutoFilter
- Exit Sub
- End If
-
- Set Sg = .Range("A" & fa.Row & ":F" & fb.Row)
- '¡´·Q°w¹ïèè¿z¿ï¥X¨Óªº½d³ò ¶i¦æ ¶i¶¥¿z¿ï¤£«½Æ ©ñ¨ìK1
- Sg.AdvancedFilter xlFilterCopy, .Range("D:D"), Sheets("¤u§@ªí2").Range("K1"), True
- End With
- End Sub
½Æ»s¥N½X ³Ì«á¦A¥Î Application.SumIfs ¥h¥[Á`¦UºØÃþªº°Ó«~¦@¦³¦h¤Ö |
|