Option Explicit
Sub TEST5()
Dim objSh1 As Worksheet ' Sheet1
Dim objSh2 As Worksheet ' Sheet2
Set objSh1 = Worksheets("Sheet1")
Set objSh2 = Worksheets("Sheet2")
' 1行1列ズラせて転記
objSh2.Range(objSh2.Cells(2, 2), objSh2.Cells(4, 5)).Value = _
objSh1.Range(objSh1.Cells(1, 1), objSh1.Cells(3, 4)).Value
End Sub
Option Explicit
Sub TEST5()
Dim objSh1 As Worksheet ' Sheet1
Dim objSh2 As Worksheet ' Sheet2
Set objSh1 = Worksheets("Sheet1")
Set objSh2 = Worksheets("Sheet2")
objSh2.Range("B2").Resize(3, 4).Value = objSh1.Range("A1").Resize(3, 4).Value
End Sub
Sub TEST6()
Dim objSh1 As Worksheet ' Sheet1
Dim objSh2 As Worksheet ' Sheet2
Set objSh1 = Worksheets("Sheet1")
Set objSh2 = Worksheets("Sheet2")
objSh2.Cells(2, 2).Resize(3, 4).Value = objSh1.Cells(1, 1).Resize(3, 4).Value
End Sub
Option Explicit
Sub TEST5()
Const cnsRange = "$A$1:$D$3"
Dim objSh1 As Worksheet ' Sheet1
Dim objSh2 As Worksheet ' Sheet2
Set objSh1 = Worksheets("Sheet1")
Set objSh2 = Worksheets("Sheet2")
objSh2.Range(cnsRange).Offset(1, 1).Value = objSh1.Range(cnsRange).Value
End Sub
Option Explicit
Sub TEST5()
Dim objSh1 As Worksheet ' Sheet1
Dim objSh2 As Worksheet ' Sheet2
Dim objRange As Range ' セル範囲
Dim strRange As String ' セル範囲アドレス
Set objSh1 = Worksheets("Sheet1")
Set objSh2 = Worksheets("Sheet2")
' Sheet1の入力範囲を取得
Set objRange = objSh1.UsedRange
strRange = objRange.Address
' 1行1列ズラせて転記
objSh2.Range(strRange).Offset(1, 1).Value = objRange.Value
End Sub
Option Explicit
Sub TEST5()
Dim objSh1 As Worksheet ' Sheet1
Dim objSh2 As Worksheet ' Sheet2
Dim lngRow As Long ' 行INDEX
Set objSh1 = Worksheets("Sheet1")
Set objSh2 = Worksheets("Sheet2")
' Sheet2の最終行を取得
lngRow = objSh2.Range("$A$" & objSh2.Rows.Count).End(xlUp).Row
' 最終行の次行を取得
If objSh2.Cells(lngRow, 1).Value <> "" Then lngRow = lngRow + 1
' 現在の収容位置の下に転記
objSh2.Cells(lngRow, 1).Resize(3, 4).Value = objSh1.Range("$A$1:$D$3").Value
End Sub