![]() |
not getting it in right place
Have following cannot seem to get flickering out of column(F) know a lot
going on there maybe some of it could come out? built this useing macro recorder. screen updating or enable events just not doing it for me. Is it lanscape change that is causeing it. If so how can it be modifyed. Or should lanscape be in a seperate module and called? hoping Thanks Sheets("Announcer").Select Application.EnableEvents = False Columns("F").Select With Selection .HorizontalAlignment = xlCenter .VerticalAlignment = xlCenter .WrapText = True .Orientation = 0 .AddIndent = False .MergeCells = False End With 'Range("G2").Select Sheets("Announcer").Select Application.EnableEvents = True Application.ScreenUpdating = False With ActiveSheet.pagesetup .LeftHeader = "" .CenterHeader = "" .RightHeader = "" .LeftFooter = "" .CenterFooter = "" .RightFooter = "" .LeftMargin = Application.InchesToPoints(0.75) .RightMargin = Application.InchesToPoints(0.75) .TopMargin = Application.InchesToPoints(1) .BottomMargin = Application.InchesToPoints(1) .HeaderMargin = Application.InchesToPoints(0.5) .FooterMargin = Application.InchesToPoints(0.5) .PrintHeadings = False .PrintGridlines = False .PrintComments = xlPrintNoComments .PrintQuality = -3 .CenterHorizontally = False .CenterVertically = False .Orientation = xlLandscape .Draft = False .PaperSize = xlPaperLetter .FirstPageNumber = xlAutomatic .Order = xlDownThenOver .BlackAndWhite = False .Zoom = 100 Application.ScreenUpdating = True .PrintArea = "A2:F" & Cells(Rows.Count, "B").End(xlUp).Row End With Application.EnableEvents = True ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True ActiveSheet.pagesetup.PrintArea = "" Range("G4").Select End Sub |
All times are GMT +1. The time now is 06:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com