ExcelBanter - Gridlines

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Gridlines (https://www.excelbanter.com/excel-programming/414217-gridlines.html)

mikerobe

Gridlines

Hi
The following macro sets up my page to print with horizontal and
vertical gridlines. Is there a way of only printing the Horizontal
gridlines.

Sheets("RDBMergeSheet").Select
With ActiveSheet.PageSetup
.Orientation = xlLandscape
.Zoom = False
.FitToPagesWide = 1
.FitToPagesTall = False
.PrintGridlines = True

End With

Thanks for any help

Eddie

Dave Peterson

Gridlines

Have you thought of turning off the gridlines and using borders.

You can put them where you want.

mikerobe wrote:

Hi
The following macro sets up my page to print with horizontal and
vertical gridlines. Is there a way of only printing the Horizontal
gridlines.

Sheets("RDBMergeSheet").Select
With ActiveSheet.PageSetup
.Orientation = xlLandscape
.Zoom = False
.FitToPagesWide = 1
.FitToPagesTall = False
.PrintGridlines = True

End With

Thanks for any help

Eddie

--

Dave Peterson

All times are GMT +1. The time now is 12:00 AM.