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

¦p¦óÅýÁ`ªíŪ¨ú¨ä¥L¤u§@ªíªº¸ê®Æ

¦p¦óÅýÁ`ªíŪ¨ú¨ä¥L¤u§@ªíªº¸ê®Æ

Á`ªí.rar (9.2 KB)

1.¦p¦óÅýÁ`ªíŪ¨ú¨ä¥L¤u§@ªíªº¸ê®Æ(µª®×¦pªþ¥óÀÉ)? (¦]¬°¨ä¥L¤u§@ªí·|¤£Â_·s¼W¸ê®Æ)

2.·í1.§¹¦¨«á¡A¬O§_¯à¦b­×§ïÁ`ªí¸ê®Æ®É¡A¨ä¥L¤u§@ªí¤]·|¦Û°Ê¦P¨B­×§ï¡H

¥H¤W­n¨¯­W¦Ñ®v¡A¸U¤À·PÁ¡I

¥»©«³Ì«á¥Ñ av8d ©ó 2016-10-26 00:16 ½s¿è

µo²{¤@­Ó°ÝÃD¡AÁ`ªíAÄæ©MBÄæ©ÒÂ^¨ú«áªº®æ¦¡·|¦Û°Ê¾a¥k¡A¥Ø«e»Ý¨D¬O§Æ±æ¯à¾a¥ª¡A§Ú¥ý¼g­Ó¥¨¶°¥ý¥Î¡A§Æ±æ¯àª¾¹D­ì¦]¡A¸U¤À·PÁ¡C

TOP

¦^´_ 10# lpk187


    ­ì¨Ó¬O§Ú§ï¿ù¦a¤è~¸U¤À·PÁÂGBKEE¤j¤j©Mlpk187¤j¤j

TOP

¦^´_ 9# av8d


    §A³o¸Ì
If E.Name <> "Á`ªí" Then
­n§ï¦¨
If E.Name <> "Á`ªí" And E.Name <> "¦ì¸m¹Ï" Then

TOP

¦^´_ 6# GBKEE


    G¤j¡A©êºp¡A¦A¦¸¥´ÂZ¡A Á`ªí.rar (21.96 KB)

¥L¶À¦â¼Ð»xªº¦a¤è¬O .Resize(UBound(E), UBound(E, 2)) = E

¦A¦¸³Â·ÐG¤j¡A¸U¤À·P¿E¡C

TOP

¦^´_ 7# av8d
¿ù»~¬O Chart ¨S¦³ Rowsª«¥ó,Worksheet ¤~¦³Rowsª«¥ó
With Sheets("Á`ªí").Range("A" & Sheets("Á`ªí").Rows.Count).End(xlUp).Offset(1)
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_ 6# GBKEE

ÁÂÁÂG¤j¡A¦pªG§Ú§â«ö¶s©ñ¦b¦ì¸m¹Ï¡A·|¥X²{«¬ºA¤£²Å¦Xªº°T®§¡A.Resize...........°ÝÃD¥X²{¦b³o¬q¡C

TOP

¦^´_ 5# av8d
  1. If E.Name <> "Á`ªí" And E.Name <> "¦ì¸m¹Ï" Then
  2. '
  3. '
  4. '
  5. Sheets("Á`ªí").UsedRange.Columns(1).NumberFormatLocal = "[$-404]e/m/d"
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_ 2# GBKEE

¦A½Ð°Ý¤@¤UG¤j¡A¦pªG§Ú¦³­Ó¤u§@ªí("¦ì¸m¹Ï")¤£·Q¥[¤JÁ`ªí·í¤¤¡A¬O§_¦³¿ìªk¡A¸U¤À·P¿E¡C

TOP

¦^´_ 3# av8d


    Range("A2", [A2].End(xlDown)).NumberFormatLocal = "[$-404]e/m/d"

TOP

        ÀR«ä¦Û¦b : «H¤ß¡B¼Ý¤O¡B«i®ð¤TªÌ¨ã³Æ¡A«h¤Ñ¤U¨S¦³°µ¤£¦¨ªº¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD