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

[µo°Ý] °j°éµ{¦¡½X¡A½Ð°Ý¬O§_¦³§ó§Öªº°õ¦æ¤è¦¡??

¥»©«³Ì«á¥Ñ mark15jill ©ó 2012-10-26 16:46 ½s¿è
½Ð°Ý¤j¤j­Ì¡A¦p¹F¨ì¤U­±°j°éµ{¦¡½X¡A¯à°÷¦³§ó§Öªº°õ¦æ¤è¦¡¶Ü??
(a1~a65535³£¦³¼Æ¦r¡A§PÂ_¬O§_¦b½d³ò¤¤¡A¦p ...
swtseng µoªí©ó 2012-10-26 14:36
  1. '²©ö§PÂ_
  2. kk = ¤u§@ªí2.Range("c1").CurrentRegion.Rows.Count
  3.     For sj = 1 To kk
  4.        For uu = 8 To 11
  5.             ¤u§@ªí1.Cells(sj, uu) = ¤u§@ªí2.Cells(sj, uu - 5)
  6.        Next
  7.     Next
½Æ»s¥N½X
sj =§PÂ_¦æ¼Æ
uu=±q N ¨ì K Äæ ( ¦b¦¹¥H 8~11Äæ ¬°¨Ò)

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

        ÀR«ä¦Û¦b : ¤H¨ÆªºÁ}Ãø»PµZ¿i¡A´N¬O¤@ºØ¦ÒÅç¡C
ªð¦^¦Cªí ¤W¤@¥DÃD