JNW,

Thanks for your response. I've taken a look at the flash help and it doesn't
allow you to get to the tick box to select fill adjacent formuals in 2003.
Thus, it won't show me where it is in 2007.

"JamesH81" wrote:

I am using MS Query to import external data. The number of rows imported
changes (inceases/decreases) based on user defined criteria. I import into
columns A-D but have a many columns linking to the data using formulas

In excel 97-2003 there was a useful little piece of functionality that
allowed you to fill adjacent formulas so as the extrnal data range
expanded/contracted the adjacent formuals and hence named rnages would also
do the same.

Does the same functionality exist in Excel 2007. I can't find it anywhere.