How do you delete rows without affecting formulas?

In general, when you write a formula:

In Cell A1:

=Sum($A$4:$A$100)

And then a macro deletes 10 Rows from that range, the formula changes to:

=Sum($A$4:$A$90)

Is there a way to fix that range even when rows are deleted?

I can think of a few workarounds [including some VBA], but I would think Excel should have an easier way already built-in.

Thanks for any help or assistance.

modytrane