Hi All,
I would like to add a code in the vba codes below to hide a selected rows in a worksheet Sheet2. Let say Row 32:41, Row 70:80 and Row 90:99.
Thanks
Sub Margins1()
With Worksheets("Sheet2").PageSetup
.Zoom = 98
'.LeftHeader = "&""Georgia Pro Black,Regular""&6&KFF0000&16& ORIGINAL" 'CHANGE HERE
'.LeftHeader = ""
'.CenterHeader = "" 'CHANGE HERE
.CenterHeader = "&""Georgia Pro Black,Regular""&6&K0000FF&10& FELONY MATRIX JULY 2020" 'CHANGE HERE
'.RightHeader = ""
'.RightHeader = "&""Rockwell Extra Bold,Regular""&6&KFF0000&14& ORIGINAL" 'CHANGE HERE
'.LeftFooter = "" 'CHANGE HERE
'.CenterFooter = ""
.CenterFooter = "&""Georgia Pro Black,Regular""&6&K0000FF&24& JULY 2020" ' CHANGE HERE
'.RightFooter = "" 'CHANGE HERE
.RightFooter = "&""Rockwell Nova Extra Bold,Regular""&6&KFF0000&24& ORIGINAL" ' CHANGE HERE
.LeftMargin = Application.InchesToPoints(0.25)
.RightMargin = Application.InchesToPoints(0.25)
.TopMargin = Application.InchesToPoints(0.5)
.BottomMargin = Application.InchesToPoints(0.7)
.HeaderMargin = Application.InchesToPoints(0.3)
.FooterMargin = Application.InchesToPoints(0.3)
.PrintHeadings = False
.PrintGridlines = False
.PrintComments = xlPrintNoComments
.PrintQuality = 600
.CenterHorizontally = True
.CenterVertically = False
.Orientation = xlLandscape
.Draft = False
.PaperSize = xlPaperLetter
.FirstPageNumber = xlAutomatic
.Order = xlDownThenOver
.BlackAndWhite = False
'.Zoom = False
.FitToPagesWide = 1
.FitToPagesTall = 1
.PrintErrors = xlPrintErrorsDisplayed
End With
Worksheets("Sheet2").PrintPreview
Application.Goto Sheets("Sheet2").Range("E3")
End Sub
Bookmarks