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

[µo°Ý] §PÂ_Excel ³Ì«á¤@Äæ ¦A¶K¤W

[µo°Ý] §PÂ_Excel ³Ì«á¤@Äæ ¦A¶K¤W

·Q½Ð°Ý¦U¦ì¤j¤j ¤£ª¾¹D­þÃ䦳°ÝÃD
§Ú­nªº°õ¦æµ²ªG¬O, ¨C¦¸°õ¦æµ{¦¡®É
¾ß¬d¸ê®Æªí³Ì«á¤@¦æ¬O¦b­þ, µM«á©¹¤U¤@¦æ ¦b¶K¤W§Ú­nªº¸ê®Æ (¾ß¬d³Ì«á¤@¦æ¸ê®Æ, ©¹¤U¤@Äæ ¶K¤W·s¸ê®Æ )
¦ý¬O¨C¦¸°õ¦æµ²ªG³£¤£¬O·Q­nªºµ²ªG, ½Ð°Ý§Ú­þÃä»Ý­n­×§ï©O??
¥Ø«e¼gªº ¶K¤W§¹ °j°é¤£·|¸õ¨«, ·|«ùÄò¨«..µM«á´N¤@ª½¶K¤W¶K¤W....
  1. For t = Range("A1048576").End(xlUp).Row To 2 Step -1
  2.         If .Cells(t + 1, "A") = "" Then
  3.             Range("A" & t + 1).Select
  4.             ActiveSheet.Paste
  5.             If .Cells(t, "A") <> Empty Then
  6.             End If
  7.         End If
  8.     Next
½Æ»s¥N½X

¦^´_ 1# v03586


    ¤w¸Ñ¨M

TOP

        ÀR«ä¦Û¦b : ®É®É¦n¤ß´N¬O®É®É¦n¤é¡C
ªð¦^¦Cªí ¤W¤@¥DÃD