LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Print Format

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
After print preview it changes the format, what could it be? The Evaluator Excel Discussion (Misc queries) 3 December 3rd 08 09:55 PM
Print on large format paper Ralph..in Edmonton Excel Discussion (Misc queries) 0 August 27th 08 02:20 AM
How to format the extension less file to print with Dos's Print Command Badshah Excel Discussion (Misc queries) 0 November 28th 06 12:44 PM
worksheet print format mark kubicki Excel Worksheet Functions 2 September 30th 05 07:41 PM
column snaking print format Montrose Lyle Excel Discussion (Misc queries) 2 April 28th 05 12:02 AM


All times are GMT +1. The time now is 11:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"