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
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
Sub M_snb() with sheets("Sheet1") .PageSetup.PrintArea = .cells(1,2).currentregion.offset(1,1).resize(,6).Address .PrintOut ,4 end with End Sub
snb, thank you..but...
... does not work the way I expected, no repeats 4 times the same impression.
thanks
look Cross-Post
http://www.mrexcel.com/forum/excel-questions/