Hello,
I am having an issues with getting my page setup right... the code below makes excel go crazy and adjusts it to 10% of its normal size and basically every cell is a pagebreak.
If i comment out the MARGIN changes it works fine and adjusts to about 58% of normal size, but i need to change the margin sizes or else it prints out a bit too small... any ideas?Code:With excelSheet.PageSetup .TopMargin = 0.25 .BottomMargin = 0.25 .LeftMargin = 0.25 .RightMargin = 0.5 .Zoom = False .FitToPagesTall = 2 .FitToPagesWide = 1 End With




Reply With Quote