Create a dynamic range name for the range and use that in the formula.

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

--
__________________________________
HTH

Bob

"HRobinson" wrote in message
...
I need to expand a data table (or 'special array' as referred to in this
discussion group) to include an additional row. Previously I have been
shown
how to do this and it worked then, but have forgotten how too!!

Across the top of the array are dates (cells D16 - J16) and on the far
left
of the array is formula referencing to a different sheet in the workbook.

I have selected the current array (using Go To - Special - Current Array)
and then expanded it for the additional line I need; also adding in the
appropriate formula that I require on the far left - pressed F2 and then
CTRL
- SHIFT - ENTER and it keeps populating with hard coded text!

I am sure this is an easy thing to do... any advise would be appreciated!!