생활/컴퓨터

엑셀 인쇄 반복 매크로

풍경소리^^ 2016. 5. 18. 16:34

Public Sub 인쇄()

    Dim sijak As Integer
    Dim machim As Integer
    sijak = Range("o1").Value
    machim = Range("p1").Value
    For sijak = Range("o1").Value To machim
        Range("o1").Value = sijak
        ActiveCell.Offset(0, 0).Value = sijak
        ActiveSheet.PrintOut
    Next sijak
End Sub