매크로 기록(절대참조, 상대참조)

절대 참조 매크로 기록

Sub Absolute()
'
' Absolute Macro
'
'
    Range("B3").Select
    ActiveCell.FormulaR1C1 = "sales"
    Range("B4").Select
    ActiveCell.FormulaR1C1 = "production"
    Range("B5").Select
    ActiveCell.FormulaR1C1 = "logistics"
    Range("B6").Select
End Sub

 

상대 참조 매크로 기록

Sub Relative()
'
' Relative Macro
'
    ActiveCell.FormulaR1C1 = "sales"
    ActiveCell.Offset(1, 0).Range("A1").Select
    ActiveCell.FormulaR1C1 = "production"
    ActiveCell.Offset(1, 0).Range("A1").Select
    ActiveCell.FormulaR1C1 = "logistics"
    ActiveCell.Offset(1, 0).Range("A1").Select
End Sub