Page Break Preview Automatically Adjusting
 

Upon using the general template of Loan Ammortization I came across a new
finding and found it quite interesting.

The sheet has builtin formulae spread over 377 rows but for example if I
insert a loan period of 2 years only the relevant part of 24 months is set as
printable area and upon changing it to 3 years the area of 36 months is
automatically set for and vice versa.

How could that be achieved?

--

Best Regards,
FARAZ A. QURESHI

Page Break Preview Automatically Adjusting
 

InsertNameDefine.

Last_Row refers to:=IF(Values_Entered,Header_Row+Number_of_Payment s,Header_Row)

See the ranges for each of those names.

Works like a Dynamic Range

Header_row is row 18 and 1st payment starts on row 19.

If there are values entered, it computes the number of rows to use based upon
the number of payments, which is based upon years and number of payments per
year.

Number of payments is Years * Months so for 2 years at 12 months you would get
24 rows which is 19:42

3 years at 12 months = 36 rows


Gord Dibben MS Excel MVP


On Thu, 10 Apr 2008 22:58:00 -0700, FARAZ QURESHI
wrote:

Upon using the general template of Loan Ammortization I came across a new
finding and found it quite interesting.

The sheet has builtin formulae spread over 377 rows but for example if I
insert a loan period of 2 years only the relevant part of 24 months is set as
printable area and upon changing it to 3 years the area of 36 months is
automatically set for and vice versa.

How could that be achieved?