ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   print range name over multiple pages (https://www.excelbanter.com/excel-programming/312885-print-range-name-over-multiple-pages.html)

Mr Mark[_2_]

print range name over multiple pages
 
I am using Excel 2000 (9.0.2720). I have a file that represents a projected
financial statement (monthly) over a three year period (so 36 columns). In
each page (sheet?) of the worksheet is a different component of the financial
statement.

Is there a way to assign a range name (such as April 2005) to the 2005
component in each of my sheets, so that the entire Statement for 2005 can be
printed by selecting one Print Range name?




All times are GMT +1. The time now is 12:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com