Naming ranges:
http://www.officearticles.com/excel/...soft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Chad Wethington" wrote in
message ...
Can you tell me how to go about naming the range?

Chad Wethington

"Anne Troy" wrote:

Sorry. I don't think you can have the best of both worlds. You could try
naming the range H8:H88 to something like MyRange, then =Sum(MyRange),
but
if you insert rows, you must insert them within the range for them to
stick.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Chad Wethington" wrote in
message ...
That seems to sum the intire column and I want to always sum is the
rows
between 8 and 88.

Chad Wethington

"Anne Troy" wrote:

Chad, why don't you try =SUM('worksheet 1'!H:H)
?
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Chad Wethington" <Chad wrote
in
message ...
On worksheet 2 I am trying to use the sum function to calculate a
range of
cells in a column on worksheet 1. My problem is that when I
insert a
row
within that sum range it expandes the formula. For example the
formula
before the inserted row would be =SUM('worksheet 1'!H8:H88), but
after
I
insert the row it changes the formula to =SUM('worksheet
1'!H8:H89).
I
don't
want it to do that. I want it to keep the exact range that I
define
in
the
first place regardless wether I insert or delete rows on worksheet
1.
Is
there a way to do this?

TIA!
Chad Wethington