Dynamic 1-year calendar

[Brian]

Hi,
I downloaded the Dynamic 1-year calendar from MS site templates.... Exactly
what i've been wanting to do. I would like to change it a bit though.. I
want to add a row to each row...
for example it would have the first day of 1 and just below that in the same
back would be some other text. How can i modify this, I am not familair
with 2007 yet. But when i try to insert a row i get ..you can not change
part of an array. Some where there has to be code for this spreadsheet, but
i can not figure out where...
Can anyone help.. or if the author is here..
thanks,
Brian

 

[Tim Zych]

I don't know the formulas in that template, but they are array formulas
applied for the whole month. To change one cell that is in an array you have
to change them all. In the top left cell, edit it and hold down ctrl + shift
while pressing enter.
To do what you want, I think you will have to:
Clear out the formulas for that month. Insert your row, reapply the formula
adjusted as needed by holding down, in edit mode, the Ctrl + Shfit + Enter.