·¸¦ì°ÝÃD,¥H¤UVBA¬°§ì¨ú¨ä¥L¤À¶¶K¨ì²Ä¤@Ó¤À¶ªºµ{¦¡,¦ý¦pªG¶W¹L65536..·|²£¥Í·¸¦ì°ÝÃD,¬O§_¦³¤j¤j¥i¥H¶i¦æ×¥¿??
«D±`·PÁÂ
¡@¡@Dim i As Long, j As Long, k As Long, n As Long
¡@¡@n = 1
¡@¡@For i = 2 To ThisWorkbook.Sheets.Count
¡@¡@For j = 1 To ThisWorkbook.Sheets(i).UsedRange.Rows.Count
¡@¡@For k = 1 To ThisWorkbook.Sheets(i).UsedRange.Columns.Count
¡@¡@ThisWorkbook.Sheets(1).Cells(n, k).Value = ThisWorkbook.Sheets(i).Cells(j, k).Value
¡@¡@Next k
¡@¡@n = n + 1
¡@¡@Next j
¡@¡@Next i |