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

¼Ï¯Ã¸ê®Æ¼ÐÃC¦â

¼Ï¯Ã¸ê®Æ¼ÐÃC¦â

Sheets("·JÁ`ªí(©ú²Óªí)").PivotTables("¼Ï¯Ã¤ÀªRªí1").PivotSelect "©|¥¼¦¬´Ú", xlDataAndLabel, True
    With Selection.Interior
        .ColorIndex = 6
        .Pattern = xlSolid
    End With

   ·Q°Ý¨Ì¤U ¤W­±¼ÐÃC¦âªº¦a¤è¥i¥H¥Î¤°»ò¤è¦¡Åý¥L¤£­n¶]±¼¶Ü
  ¦pªG§Úªºµe­±¬O°±¦b Sheets("·JÁ`ªí(©ú²Óªí)")³o¦Uªí´N¤£·|¶]±¼
  ¥i¬O¦pªG¦b§Oªº¤u§@ªí¦A°õ¦æ¸Óµ{¦¡½X´N·|¦b§Oªº¤u§@ªí©Ò¦bÀx¦s®æ¼ÐÃC¦â

  §Ú·Q­nªº¬O¤W­±ªºµ{¦¡½X¦³¿ìªk¦b²²¤¶Ü? §_«h¦n¹³¥u¯à§ï¦¨¤U­±ªº¶Ü?
  Sheets("·JÁ`ªí(©ú²Óªí)").PivotTables("¼Ï¯Ã¤ÀªRªí1").PivotSelect "©|¥¼¦¬´Ú", xlDataAndLabel, True
Sheets("·JÁ`ªí(©ú²Óªí)").select
    With Selection.Interior
        .ColorIndex = 6
        .Pattern = xlSolid
    End With
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

        ÀR«ä¦Û¦b : ¡i°±º¢¤£«e¡A²×µL©Ò±o¡j¤H³£°g©ó´M§ä©_ÂÝ¡A¦]¦Ó°±º¢¤£«e¡FÁa¨Ï®É¶¡¦A¦h¡B¸ô¦Aªø¡A¤]¤FµL¥Î³B¡A²×µL©Ò±o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD