Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a number of similar worksheets that I want to open through a script
and print only the last page of data. Each worksheet has varrying amounts of data that change each month so I have a formula in each (in cell G1) that displays the range equal to the last page of data (formula evaluates to A125:E156 for instance). As I open each worksheet with the script, how do I set the Print Range equal to the range the formula returns? Thanks, Pete |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Print Area Setting | Excel Discussion (Misc queries) | |||
Setting The Print-Area ? | New Users to Excel | |||
Setting print area | Excel Discussion (Misc queries) | |||
Setting print area with vba | Excel Programming | |||
Setting print area | Excel Programming |