| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PAGEBREAK-MACRO
I am looking for a macro that will set any Excel sheet's page (no
mattet how many pages the page-break view shows) to just one page. I would appreciate any assistance. Thanks. Jay Dean. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
PAGEBREAK-MACRO
Hi Jay:
With ActiveSheet.PageSetup .FitToPagesWide = 1 .FitToPagesTall = 1 End With Regards, Vasant. "Jay Dean" wrote in message om... I am looking for a macro that will set any Excel sheet's page (no mattet how many pages the page-break view shows) to just one page. I would appreciate any assistance. Thanks. Jay Dean. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
PAGEBREAK-MACRO
You might want to add:
With ActiveSheet.PageSetup .Zoom = False .FitToPagesWide = 1 .FitToPagesTall = 1 End With -- Regards, Tom Ogilvy Vasant Nanavati wrote in message ... Hi Jay: With ActiveSheet.PageSetup .FitToPagesWide = 1 .FitToPagesTall = 1 End With Regards, Vasant. "Jay Dean" wrote in message om... I am looking for a macro that will set any Excel sheet's page (no mattet how many pages the page-break view shows) to just one page. I would appreciate any assistance. Thanks. Jay Dean. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help coding a PageBreak | Excel Discussion (Misc queries) | |||
| Cant move pagebreak in PageBreak View in Excel2003 | Excel Worksheet Functions | |||
| Can I keep rows together so they don't separate at a pagebreak? | Excel Discussion (Misc queries) | |||
| Excel 2000 PageBreak problem | Excel Discussion (Misc queries) | |||
| how to set excel pagebreak in programm | Excel Programming | |||
Linear Mode
