Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi, in my workbook I have 38 sheets (names). Where you can add and delete as
you like. My last sheet "Summary" has got each month horizontally and different names vertically. Where each name has a value for every month. Now, these cells (range) all have borders. When printing this sheet it doesn't print my borders. The code... Dim count as Integer = Getsheets() - This gets the last sheet in my workbook (Summary) Dim sheet As Excel._Worksheet = CType(book.Sheets.Item(Count), Excel._Worksheet) With sheet .PageSetup.Orientation = Excel.XlPageOrientation.xlLandscape .PageSetup.TopMargin = 0 .PageSetup.BottomMargin = 0 .PageSetup.LeftMargin = 0 .PageSetup.RightMargin = 0 .PageSetup.Draft = True .PageSetup.PrintGridlines = True .PrintOut() End With |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
After print preview it changes the format, what could it be? | Excel Discussion (Misc queries) | |||
Print on large format paper | Excel Discussion (Misc queries) | |||
How to format the extension less file to print with Dos's Print Command | Excel Discussion (Misc queries) | |||
worksheet print format | Excel Worksheet Functions | |||
column snaking print format | Excel Discussion (Misc queries) |