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

[µo°Ý] Äæ¼Æ¤Þ¥Îªº¤p°ÝÃD_¥Î¼Æ¦r¨ú¥N­^¤å¦r¥À

[µo°Ý] Äæ¼Æ¤Þ¥Îªº¤p°ÝÃD_¥Î¼Æ¦r¨ú¥N­^¤å¦r¥À

½Ð°Ý°ª¤â¤j¤j,
¤@­Ó¤p°ÝÃD¡A·Pı«Ü²³æ¡A«o¤@ª½§ä¤£¨ìµª®×????
¦p¥H¤U¨Ò¥y:
Columns("A:B").Interior.ColorIndex = 4

§Ú·Q­n¥Î¼Æ¦r 1 ¨ú¥NA, 2¨ú¥NB
Columns("1:2").Interior.ColorIndex = 4
©Î
Columns(1:2).Interior.ColorIndex = 4

³£¤£¥i¦æ¡AÀ³¸Ó¬O­n«ç»ò¼g©O?

¥ý·PÁ¦U¦ì¤j¤j¤F~

¦^´_ 1# swatt
¤@Äæ¤@Äæ¾Þ§@
For i = 1 To 2
Columns(i).Interior.ColorIndex = 4
Next
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh


  ÁÙ¬O­n¶]°j°é³á¡A¦]¬°¸ê®Æ¶q¤ñ¸û¤j¡A¥»¨Ó¬O·Q­n¬ÙÂI®É¶¡....
  ·PÁ¶W¯Åª©¥D¦^ÂÐ~

TOP

¦^´_ 3# swatt
¸Õ¸Õ¬Ý
  1. Option Explicit
  2. Sub Ex()
  3.     Columns(2).Resize(, 5).Interior.ColorIndex = 4
  4.     '¦p"B:F"-> Resize(, 5)=5Äæ
  5. End Sub
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_ 4# GBKEE


©êºp, ¤@¬q®É¶¡¨S¤W¨Ó©Ò¥H¨Sª`·N¨ì...
¦¹¤èªk¥i¦æ¡A·PÁÂGBKEE¶W¯Åª©¥D~

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¤Hªº§Ö¼Ö¡D¤£¬O¦]¬°¥L¾Ö¦³±o¦h¡A¦Ó¬O¦]¬°¥L­p¸û±o¤Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD