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

Top