i.e.
Sub SetPrintRanges(StartCell As String) For i = 1 To Sheets.Count Worksheets(i).PageSetup.PrintArea = startcell & ":" & _ Worksheet(i).Cells.SpecialCells(xlCellTypeLastCell).Address Next i End Sub
![]()
i.e.
Sub SetPrintRanges(StartCell As String) For i = 1 To Sheets.Count Worksheets(i).PageSetup.PrintArea = startcell & ":" & _ Worksheet(i).Cells.SpecialCells(xlCellTypeLastCell).Address Next i End Sub
![]()
Last edited by Aussiebear; 04-29-2023 at 06:46 PM. Reason: Adjusted the code tags
"Computers are useless. They can only give you answers." - Pablo Picasso
Mark Rowlinson FIA | The Code Net