Use named ranges for the formula elements. If you already have your
formulas, create the named ranges then highlight the area where your
formulas are and choose apply. If you haven't created the formulas
yet, create the named ranges and use your mouse to click on the cells
rather than typing the cell address.


--
Chris Berry
------------------------------------------------------------------------
Chris Berry's Profile: http://www.excelforum.com/member.php...o&userid=36165
View this thread: http://www.excelforum.com/showthread...hreadid=574411