ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] VBA ¦¨ÁZ§C©ó60¼Ð¥Ü¬õ¦r

[µo°Ý] VBA ¦¨ÁZ§C©ó60¼Ð¥Ü¬õ¦r

¤S¨Ó½Ð±Ð¦U¦ì°ª¤â !!
IF then ¤@ª½³£µ{¦¡¥¢±Ñ:Q ¡A¦p¦óvba¼¶¼g¦b¦¨ÁZÄæ¦ì§C©ó60¼Ð¥Ü¬õ¦r
ÁÂÁÂ!!:)
Book1.rar (1.35 KB)

Sub test()
Dim c As Range
For Each c In Range([b2], [b65536].End(3))
If c.Value < 60 Then c.Font.ColorIndex = 3
Next
End Sub

TOP

¦^´_ 2# oobird


    ÁÂÁÂ ^^

TOP

¥i¥Hªº¸ÜºÉ¶q¥Î®æ¦¡¤Æ±ø¥ó
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

¤£¦n·N«ä,¥i¥H°Ý¤@¤U¶Ü?For Each c In Range([b2], [b65536].End(3))³Ì«áªº(3)¬O¤°»ò·N«ä©O?
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

[b65536].End(3)=[b65536].End(xlup)

TOP

        ÀR«ä¦Û¦b : ¤â¤ß¦V¤U¬O§U¤H¡A¤â¤ß¦V¤W¬O¨D¤H¡F§U¤H§Ö¼Ö¡A¨D¤Hµh­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD