| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically update print area
Hi, I have a workbook that we use every year. Every year new rows ar added to the sheets for the current activity since last used. It is pain to have to go and change the print area for each sheet again afte these changes. Any ideas how I can write a macro to automaticall calculate the print area for each worksheet and then print? Thanks so much -- Sheen ----------------------------------------------------------------------- Sheeny's Profile: http://www.excelforum.com/member.php...nfo&userid=908 View this thread: http://www.excelforum.com/showthread.php?threadid=53892 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to automatically set print area in Excel template? | Excel Worksheet Functions | |||
| Can Excel automatically select print area on non-blank cells? | Excel Discussion (Misc queries) | |||
| Plot Area Automatically Expands in Print and Print Preview | Charts and Charting in Excel | |||
| how do i update a chart area automatically | Charts and Charting in Excel | |||
| Create a print macro that would automatically select print area? | Excel Worksheet Functions | |||
![Sheeny[_24_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
