Hi Guys
Having trouble removing print preview lines
i set the print area and it automatically puts in a print preview line in column 4
Which i cant remove so when i print, it prints 2 pages instead of one.
heres my code
Having trouble removing print preview lines
i set the print area and it automatically puts in a print preview line in column 4
Which i cant remove so when i print, it prints 2 pages instead of one.
heres my code
VBA Code:
worksheets(ws).PageSetup.PrintArea = Sheets(ws).Cells(1, 1).Resize(lr + 10, 4).Address
Worksheets(ws).Columns(4).PageBreak = xlPageBreakNone