Gridlines

M

mikerobe

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
 
D

Dave Peterson

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

You can put them where you want.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Page set up for all worksheets 7
Page Breaks in VBA Q 6
Print area - selection 4
Printing-don't need half this code but which half?:-) 5
set print area on multiple sheets 4
Print sub returns 4
Macro for Page Setup - Fit to one page 1
Excel Automation - Gridlines 3

Top