- ©«¤l
- 231
- ¥DÃD
- 55
- ºëµØ
- 0
- ¿n¤À
- 293
- ÂI¦W
- 0
- §@·~¨t²Î
- winxp
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- KEELUNG
- µù¥U®É¶¡
- 2010-7-24
- ³Ì«áµn¿ý
- 2018-8-28
|
¦^´_ 7# wwh126
¤j¤j§A¦n¡G
Hsiehª©¥D¤j¤j¦³»¡©ú¦pªG¬On
pºâ²Å¦X±ø¥ó®æ¦¡¬°ÂŦ⪺Àx¦s®æ¼Æ¶q¡A
¨ºn°w¹ï®æ¦¡±ø¥ó°µpºâ¡C
©Ò¥H¡AÀ³¸ÓµLªkª½±µ¨Ì¤w®æ¦¡¤Æªº
Àx¦s®æÃC¦â°µpºâ¡C
¬O§_¥i§ï¦¨°w¹ï®æ¦¡±ø¥ó¨Ó°µpºâ©O¡H
¨Ò¦p¡G
a2:a20Àx¦s®æ³]©w¤j©ó100®É¡A
ÃC¦âÅã¥Ü¬°ÂŦâ¡C
Sub aa()
Dim mSht As Worksheet
Dim mRng As Range, mRng1 As Range
Dim s%
Set mSht = acitvesheet
With mSht
Set mRng1 = .Range("a2", .Range("a" & .Rows.Count).End(xlUp))
For Each mRng In mRng1
If mRng.Value > 100 Then
s = s + 1
End If
Next
.Range("c1") = "²Å¦X®æ¦¡±ø¥ó¦Xp ¡G" & s
End With
End Sub |
|