BucketWeight = weights(bucket)

Just a guess but since I don't recognize the weights() function, I'm
guessing Excel might not either? That would explain a #Name error.

Any chance there is a User defined function (or more than one) in a
Personal.xls file that existed on yesterday's machine but not on today's?

HTH,
--
George Nicholson

Remove 'Junk' from return address.


"idgity" wrote in message
...
Hi,

I'm new to making VB functions for Excel, but I managed to make one
yesterday that was producing the results I wanted. Now today, after
copying
the excel file to a different computer, the function gives me the #Name?
error, even though I haven't changed it or it's arguments. Alt+F11 shows
the
function, but the spreadsheet doesn't seem to recognize it. What do I
do?
Here is the (very simple) function:

Function BucketWeight(bucket, weights)
BucketWeight = weights(bucket)
End Function

bucket is a number and weights should be an array. I'm calling it like:
=BucketWeight($D3, $B$485:$B$489)

Thanks a lot!