¼x¨D°ª¤âÀ°§Ú¸Ñ¨M¤@¤U³oÓ°ÝÃD
- ©«¤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
|
¦^´_ 1# ÂŤÑÄR¦À
´£¨Ñ°Ñ¦Ò¡G- .[A3].Resize(1, 8).Font.FontStyle = "²ÊÅé"
½Æ»s¥N½X |
|
|
|
|
|
|
- ©«¤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
|
¦^´_ 4# ÂŤÑÄR¦À - Sub RecordPrice()
- Dim WR As Long
- ' ActiveWindow.ScrollRow = WR - 5 ' ¥uÅã¥Ü³Ì·s´Xµ§¸ê®Æ
- Application.ScreenUpdating = False
- With Sheets("RTD")
- If .Range("H2") < 1 Then Exit Sub
- WR = Range("A1").End(xlDown).Row + 1
- If (WR = 3) Or _
- (.Range("G" & WR - 1) <> .Range("G2")) Then ' Á`¶q¦³²§°Ê®É¤~°O¿ý
- .Rows(3).Insert
- .[A3].Resize(1, 8) = .[A2].Resize(1, 8).Value
- .[A3].Resize(1, 8).Font.FontStyle = "²ÊÅé"
- End If
- End With
- Application.ScreenUpdating = True
- End Sub
½Æ»s¥N½X |
|
|
|
|
|
|
- ©«¤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
|
¥»©«³Ì«á¥Ñ c_c_lai ©ó 2015-12-29 08:03 ½s¿è
¦^´_ 6# ÂŤÑÄR¦À
. |
|
|
|
|
|
|
- ©«¤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
|
¦^´_ 6# ÂŤÑÄR¦À - If (WR = 3) Or _
- (.Range("G" & WR - 1) <> .Range("G2")) Then ' Á`¶q¦³²§°Ê®É¤~°O¿ý
½Æ»s¥N½X »P- If (WR = 3) Or _
- (.Range("G" & WR - 1) <> .Range("G2")) Then ' Á`¶q¦³²§°Ê®É¤~°O¿ý
½Æ»s¥N½X ¬OÓ§¹¥þ¤£¦Pªº±Ôz¡A¡y_¡z±µÄòªº»y¥y«á±¬O¤£¯à¦³ªÅ¦æªº¡A§_«h·|¬OÓ¡u¤£¦Xªkªº»yªk¡v¡C
¥t¥~§AnþÓ³¡¦ìnÅã¥Ü¡y²ÊÅé¡z¡A¬O§AÓ¤H¦Û¦æ³]©wªº¡C½d¨Ò¥u¬On§i¶D§A³]©wªº¤èªk¡A
.[A3].Resize(1, 8).Font.FontStyle = "²ÊÅé" ¬O³]©w¸Ó¦æ¥þ¬°¡y²ÊÅé¡z¡AY§A¥un G Äæ³]©w¬°
¡y²ÊÅé¡z¡A«h«KÀ³§ï¦¨ .[G3].Font.FontStyle = "²ÊÅé"¡CÀH§AÓ¤H¤§À³¥Î¡C°²³] G2 > 9 ¤~ÅÜ
¬°²ÊÅé¡A«h§ó§ï¦¨¡u .[G3].Font.FontStyle = IIf(.[G2] > 9, "²ÊÅé", "¼Ð·Ç")¡v§Y¥i¡C |
|
|
|
|
|
|
- ©«¤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
|
¥»©«³Ì«á¥Ñ c_c_lai ©ó 2015-12-29 19:00 ½s¿è
¦^´_ 9# ÂŤÑÄR¦À
¤£¦n·N«ä½Ð°Ý¡u¦P®æ¦¡¤Æ±ø¥ó¡v«üªº¬O¬Æ»ò¡H
¯à§_»¡©ú¤@¤U¡A³o¼Ë§Ú¤~ª¾§Anªº¬O¤°»ò¡C
³Ì¦n¦³Ó¨Ò¤lµe¸¬¤@¤U¡A¦]¬°§ÚÁÙ¨S¤ÏÀ³¹L¨Ó¡C |
|
|
|
|
|
|
- ©«¤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
|
¦^´_ 11# ÂŤÑÄR¦À
|
|
|
|
|
|
|
- ©«¤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
|
|
|
|
|
|
|
- ©«¤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
|
¦^´_ 18# ÂŤÑÄR¦À
§Ú²×©ó¤F¸Ñ§Aªº·N«ä¤F¡C
¦]¬°·íªì§Aªºì©lµ{¦¡¸Ì¡A¦³¦p¤U¤§±ø¥ó¡G
(1)
If .Range("H2") < 1 Then Exit Sub ' ·í H2 Ȥp©ó 1 ®É«h¤£³B²z¡Aª½±µ³w¦æ¸õÂ÷¡C
(2)
WR = Range("A1").End(xlDown).Row + 1
If (WR = 3) Or (.Range("G" & WR - 1) <> .Range("G2")) Then ' Á`¶q¦³²§°Ê®É¤~°O¿ý
·í©Ò¦³¬ö¿ý¬°ªÅ¡A¥ç©Î¬O G2 ÄæÈ»P ³Ì«á¤@µ§ªºÈ ¤£µ¥®É¤~¥h¼g¤J²Ä¤T¦C (Rows(3)) ¤§
¸ê®Æ¡C§AÀˬd¤@¤U§A¸ê®Æ¿ý³Ì«á¤@µ§¤§ G ÄæȬ°¦ó¡A¬O§_»P G2 ÄæȤ@P¡H
¦]¬°§Ú¤£ª¾§Aì¥ý·N¹Ï¬°¦ó¡A¥u¯à·Ó¼g¤J¡C ±q ²Ä¤T¦Cªº¶×¤J (.Rows(3).Insert) ¤è¦¡¨Ó¬Ý¡A
¨Ì§ÚÓ¤Hªº³B²z²ßºD¡A§Ú¬O¤£·|®³¸ê®Æ¿ý³Ì©³¤U(³Ì«á)¤@µ§ªº°O¿ý¤§È°µ¤ñ¹ï¡A¦]¬°¥Ø«e¤§
²Ä¤T¦Cªº¶×¤JȤ~¬O§A³Ì«á¤§¶×¤JÈ (³Ì·sªº¶×¤JÈ)¡C©Ò¥H¸g§A¤@»¡§Ú¤~©ú¤F§A³Ì«áªí¹Fªº·N«ä¡C
À³¸Ó¬O¡G- If (WR = 3) Or (.[G3] <> .[G2]) Then ' Á`¶q¦³²§°Ê®É¤~°O¿ý
½Æ»s¥N½X |
|
|
|
|
|
|
- ©«¤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
|
¦^´_ 21# ÂŤÑÄR¦À - Sub RecordPrice() ' ±q²Ä¤T¦æ´¡¤J¼Ò¦¡
- Dim WR As Long
- Application.ScreenUpdating = False
- With Sheets("RTD")
- If .Range("H2") < 1 Then Exit Sub
- WR = Range("A1").End(xlDown).Row + 1
- If (WR = 3) Or (.[G3] <> .[G2]) Then ' Á`¶q¦³²§°Ê®É¤~°O¿ý
- .Rows(3).Insert
- .[A3].Resize(1, 8) = .[A2].Resize(1, 8).Value
- .[G3].Font.FontStyle = IIf(.[G2] > 9, "²ÊÅé", "¼Ð·Ç")
- .[G3].Font.Color = IIf(.[G2] > 9, 255, 2)
- End If
- End With
- Application.ScreenUpdating = True
- End Sub
½Æ»s¥N½X |
|
|
|
|
|
|
- ©«¤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
|
¦^´_ 20# ÂŤÑÄR¦À - Sub RecordPrice() ' ©¹¤U»¼¼W¼Ò¦¡
- Dim WR As Long
- Application.ScreenUpdating = False
- With Sheets("RTD")
- If .Range("H2") < 1 Then Exit Sub
- WR = Range("A1").End(xlDown).Row + 1
- If (WR = 3) Or (.Range("G" & WR - 1) <> .[G2]) Then ' Á`¶q¦³²§°Ê®É¤~°O¿ý
- .Range("A" & WR).Resize(1, 8) = .[A2].Resize(1, 8).Value
- .Range("G" & WR).Font.FontStyle = IIf(.[G2] > 9, "²ÊÅé", "¼Ð·Ç")
- .Range("G" & WR).Font.Color = IIf(.[G2] > 9, 255, 2)
- End If
- End With
- Application.ScreenUpdating = True
- End Sub
½Æ»s¥N½X |
|
|
|
|
|
|