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

°õ¦æVBA«á¡A¥k¤è±²¶b¬°¦óÅܦ¨¥i©Ô¨ì65536?

°õ¦æVBA«á¡A¥k¤è±²¶b¬°¦óÅܦ¨¥i©Ô¨ì65536?

°õ¦æ¥¨¶°«á¡A½Ð°Ý¦p¦ó­×§ïVBA¡A¥HÁקK±²¶b¤£­nÅܦ¨¥i©Ô¨ì65536? ¦pªþÀÉ¡AÁÂÁÂ! Book33.rar (7.38 KB)

¦^´_ 1# winston219
µ{¦¡¦bµ¹­È®É¨Ï¥Î¾ãÄæ¾É­P§A¹ïENDªº¿ùı
  1. Sub yy()
  2. [a:a].HorizontalAlignment = xlCenter
  3. Range("a2:a" & [b65536].End(3).Row) = "=row()-1"
  4. Range("a2:a" & [b65536].End(3).Row) = Range("a2:a" & [b65536].End(3).Row).Value
  5. End Sub
½Æ»s¥N½X
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

«¢¡A¥i¦æ¤F¡A·PÁÂHsieh¤j¤jªº»¡©ú~

TOP

        ÀR«ä¦Û¦b : ¡i¬°µ½Ävª§¡j¤H¥Í­n¬°µ½Ävª§¡A¤À¬í¥²ª§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD