½Ð±Ð¦U¦ì¤j¨Ð¡A§Ú¶}¤F«Ü¦hsheets¡A¦U¦³¨ä¦WºÙ¡A±q¨C¤@Ósheets¦U½Æ»s©T©wªºÀx¦s®æ¨ì²Ä¤@Ósheet¡A©Ò¥H§Ú·Q¨ì¥Î°j°é
¤£¹L«o¹J¨ì°ÝÃD¡G
¤U¦C¬O§Úªºµ{¦¡½X¡A½Ð°Ý¬OþÃä¥X°ÝÃD¡A©Î¬O¦³¨ä¥L§ó¦nªº¤èªk¥i¥H§¹¦¨³oµ{¦¡??
½Ð¦U¦ì¤j¨Ð¤£§[½ç±Ð~ÁÂÁÂ~
Private Sub CommandButton1_Click()
Dim a As Integer
For a = 2 To 5
Sheets(a).Select
Range(Cells(3, 2), Cells(5, 11)).Select
Selection.Copy
Sheets(1).Select
Range(Cells(3, 2), Cells(5, 11)).Select
ActiveSheet.Paste
Next
End Sub |