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

½Ð°Ý : ¦p¦ó¥Hµ{¦¡½Æ»s Row ¨ì¥t¤@­Ó Sheet ..

½Ð°Ý : ¦p¦ó¥Hµ{¦¡½Æ»s Row ¨ì¥t¤@­Ó Sheet ..

¥»©«³Ì«á¥Ñ GBKEE ©ó 2015-2-20 15:23 ½s¿è

¬O³o¼Ëªº
¤p©f·Q±N Sheet2 ¤¤ªº Row1 ¾ã¦æ½Æ»s¨ì Sheet1 ¤¤ªº Row1 ¶K¤W( ²[¦¡¶K¤W«D¥u¶K¼Æ­È )
·Q»¡³o­Ó°Ê§@«Ü²³æ
µ²ªG¹ê»Ú¤W«o¸I¨ì¤@°ï°ÝÃD
³o¬O§Úª¦¤F¦n¦h¤å¼g¥X¨Óªº

'Sheets("Sheet2").Select
'Rows("1:1").Select
'Selection.Copy
'Sheets("Sheet1").Select
'Rows("1:1").Select
'Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
'SkipBlanks:=False, Transpose:=False

¨C 5 ¬í°õ¦æ¤@¦¸
¦ý§Úµo²{³o¼Ë®Ú¥»¤£¦æ , Excel ·|¤@ª½¸õ¦^ Sheet1
³o¼Ë§Ú³£¤£¯à°µ¨ä¥Lªº¨Æ¤F....
«á¨Ó§Ú´Nª¦¤F§ó¦h¤å
µo²{©~µM¤¤¤å­^¤å³£§ä¤£¨ì³o»ò²³æ°ÝÃDªº¸Ñµª...Orz

ÁٽЦU¦ì¤j¤jÀ°À°¤p©f¤F
¤p©f¦b¦¹¦V¦U¦ì¤j¤j¨D±Ð¤F Orz

Sheet2.Rows(1).Copy
Sheet1.Rows(1).PasteSpecial

TOP

¦^´_ 2# bobomi


ÁÂÁÂ bobomi ¤j
¥H¸Ñ¨M¤F..
§Ú¦n²Âªü  :'(
¤p©f¦b¦¹¦V¦U¦ì¤j¤j¨D±Ð¤F Orz

TOP

¥»©«³Ì«á¥Ñ lpk187 ©ó 2015-2-20 21:22 ½s¿è

Sheets("Sheet2").Select
Sheets("Sheet1").Rows("1:1") = Sheets("Sheet2").Rows("1:1").FormulaLocal

¥Îcopy¦³®É·|§â®æ½u¤]½Æ»s ¹L¨Ó¦pªG¥u­n½Æ»s¤½¦¡¥u­n¥[¤W¤½¦¡ÄÝ©Ê".FormulaLocal"´N¥i¥H¤F

TOP

¥i¥H¸Õ¸Õ
Sheets("Sheet2").Rows(1).Copy Sheets("Sheet1").Cells(1, 1)

TOP

        ÀR«ä¦Û¦b : ¯à·F¤£·F¡A¤£¦p­W·F¹ê·F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD