You would think so but this fails with a 1004 error

```
Rem This macro is running on sheet2

Dim avg As double

Names.Add Name:="sheet1Avg", RefersTo:="sheet1!$C$2:$C$24"
avg = Application.WorksheetFunction.Average(range("sheet1Avg"))

```

So does this:

```
avg = Application.WorksheetFunction.Average(range("sheet1!$C$2:$C$24))

```

I would hate to have to copy `C2:C24` to the active sheet every time I wanted to use a math function.

Any ideas?