Prev: Finding Values of X
Next: =OFFSET(MATCH(My frustration continues!))
From: mikerobe on 17 Jul 2008 19:26
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
From: Dave Peterson on 17 Jul 2008 19:59
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
 | 
Pages: 1
Prev: Finding Values of X
Next: =OFFSET(MATCH(My frustration continues!))