In Excel 2003 (all earlier): Insert | Name | Define
Give a name ( I used MYAVG)
Enter in refers to: =AVERAGE(Sheet1!$D$12:$G:12)
best wishes--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Gene" wrote in message
...
I have the following function (this is a "simple" example):
=IF(ISERROR(AVERAGE(D12:G12)),"No Data",AVERAGE(D12:G12))

I don't want to retype, the "AVERAGE (D12:G12)" argument, can I use a
"define name" to replace this functional argument? (here in a very simple
format)
THANKS!
Gene:)