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!