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

[µo°Ý] «ü©w¤u§@ªí¦WºÙ°ÝÃD

[µo°Ý] «ü©w¤u§@ªí¦WºÙ°ÝÃD

½Ð°Ý¦U¦ì¤j¤j¡A§Ú¦³¤@­ÓÀɮ׸̭±·|¨C­Ó¤ë¼W¥[2­Ó¤u§@ªí
°²³]¤@­Ó¤u§@ªí¦W¬O¡y08¡z¡A¤@­Ó¬O¡y08Á`¡z
½Ð°Ý§Ú¸Ó«ç»ò¼g¡A¤~¯à«ö¤U«ö¶s«á¡AÅýªí¡y08¡z­n­pºâªº­È¡A¦Û°Ê°»´ú¹ïÀ³ªº¦WºÙ¡A¦Ó±a¤J¡y08Á`¡zªºÀx¦s®æp1¸Ì¡H(¹³¦b¡y07¡zªºªí«ö¡A´N·|±a¨ì¡y07Á`¡z)
¦]¬°§Ú¼g¡GSheets(ActiveSheet.Name).[p1] = Application.Average(Range("b4:b8"))¡A³o¼Ë¥i¥H°õ¦æ
¥i¬O¼g³o¼Ë¡GSheets(ActiveSheet.Name&"Á`").[p1] = Application.Average(Range("b4:b8"))¡A´N¥¢±Ñ¤F¡K
¥i¥H½Ð¦U¦ì°ª¤âÀ°§Ú«üÂI¤@¤U¶Ü¡AÁÂÁÂ~

¦^´_ 1# mei27
  1.     Sheets(ActiveSheet.Name & "Á`").[p1] = Application.Average(Range("b4:b8"))
½Æ»s¥N½X
¸Õ¸Õµ¹&«e«á¤@ÂIªÅ¶¡(ªÅ®æ)
½T»{¤@¤U¬O¦b 07/08 ¹B¦æ, ¤£¬O¦b07Á`/08Á`¹B¦æ
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

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

TOP

¦^´_ 2# kimbal

Kimbal¤j¡AÁÂÁ§A¡A­ì¨Ó¬O§Úªº&¤§¶¡¨S¦³ªÅ®æªºÃö«Y...
§â&«e«á¦UªÅ¤@®æ¤§«á´N¦æ¤F¡A·P®¦~

TOP

        ÀR«ä¦Û¦b : ¨ü¤HÂI¤ô¤§®¦¡A¶··í´é¬u¥H³ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD