Consulting

Results 1 to 4 of 4

Thread: Run Macro 4 time

  1. #1

    Run Macro 4 time

    I try repeat this code 4 times
    Sub Repeat_Four_Time()
    Dim Rep As Long
    
    
    For Rep = 1 To 4
    Worksheets("Sheet1").PageSetup.PrintArea = Range("B2", Range("G65536").End(xlUp).Offset(2)).Address
    ActiveSheet.PrintOut
    Next Rep
    
    
    End Subb

  2. #2
    Sub M_snb() 
       with sheets("Sheet1")
         .PageSetup.PrintArea = .cells(1,2).currentregion.offset(1,1).resize(,6).Address 
         .PrintOut ,4
       end with
    End Sub

  3. #3
    snb, thank you..but...
    ... does not work the way I expected, no repeats 4 times the same impression.

    thanks

  4. #4

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •