But when they re-edit the worksheets all of the
formulas need to be rewritten for the new length.

Do you mean the formulas need to be adjusted for the range size?

Use dynamic ranges:

http://contextures.com/xlNames01.html#Dynamic

Biff

"kermitforney"
wrote in message
news:kermitforney.24ryna_1142533203.1037@excelforu m-nospam.com...

I am creating a spread sheet and need to know if I can have the formulas
change if needed?

This is basically a short template 100-150 rows but it flucuates
depending on the user. But when they re-edit the worksheets all of the
formulas need to be rewritten for the new length.

Is there anyway I can bind the formulas or somehow have them resize
automatically based on certain criteria?


--
kermitforney
------------------------------------------------------------------------
kermitforney's Profile:
http://www.excelforum.com/member.php...o&userid=32536
View this thread: http://www.excelforum.com/showthread...hreadid=523211