'Book1.xlsのSheet1のA1セルの内容を 'Book2.xlsのSheet1のA1セルにコピーします Sub セルの内容をコピー()
' 宣言 Dim objWorkSheet1 As Worksheet 'book1のSheet1 Dim objWorkSheet2 As Worksheet 'book2のSheet1
Dim objRange1 As Range 'book1のSheet1のA1 Dim objRange2 As Range 'book2のSheet1のA1
'ワークシートオブジェクトを取得 Set objWorkSheet1 = Application.Workbooks.Item("Book1.xls").Sheets.Item("Sheet1") Set objWorkSheet2 = Application.Workbooks.Item("Book2.xls").Sheets.Item("Sheet1")
'Rangeオブジェクトを取得 Set objRange1 = objWorkSheet1.Range("A1") Set objRange2 = objWorkSheet2.Range("A1")