#Name? Error in User Defined VB Function

> 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" <[email protected]> wrote in message
news:[email protected]...
> 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!

Ah, that might be it, I was defining a whole bunch of functions yesterday and
one of them might have been called "weights". Funny that it was giving the
right answers though. But I mean for weights to be an array of values passed
in to the function, not another function. I'm passing in a chunk of an
excel column. How do you tell VB it's an array? I've tried:
Function BucketWeight(bucket, weights())
and
Function BucketWeight(bucket, weights() As Integer)
but I still get #Name?

Sorry these are very basic (ha) questions, but I'm used to C++ and java.

Thanks.

"George Nicholson" wrote:

> > 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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!
>
>
>

> 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" <[email protected]> wrote in message
news:[email protected]...
> 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!

Ah, that might be it, I was defining a whole bunch of functions yesterday and
one of them might have been called "weights". Funny that it was giving the
right answers though. But I mean for weights to be an array of values passed
in to the function, not another function. I'm passing in a chunk of an
excel column. How do you tell VB it's an array? I've tried:
Function BucketWeight(bucket, weights())
and
Function BucketWeight(bucket, weights() As Integer)
but I still get #Name?

Sorry these are very basic (ha) questions, but I'm used to C++ and java.

Thanks.

"George Nicholson" wrote:

> > 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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!
>
>
>

> 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" <[email protected]> wrote in message
news:[email protected]...
> 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!

Ah, that might be it, I was defining a whole bunch of functions yesterday and
one of them might have been called "weights". Funny that it was giving the
right answers though. But I mean for weights to be an array of values passed
in to the function, not another function. I'm passing in a chunk of an
excel column. How do you tell VB it's an array? I've tried:
Function BucketWeight(bucket, weights())
and
Function BucketWeight(bucket, weights() As Integer)
but I still get #Name?

Sorry these are very basic (ha) questions, but I'm used to C++ and java.

Thanks.

"George Nicholson" wrote:

> > 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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!
>
>
>

> 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" <[email protected]> wrote in message
news:[email protected]...
> 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!

Ah, that might be it, I was defining a whole bunch of functions yesterday and
one of them might have been called "weights". Funny that it was giving the
right answers though. But I mean for weights to be an array of values passed
in to the function, not another function. I'm passing in a chunk of an
excel column. How do you tell VB it's an array? I've tried:
Function BucketWeight(bucket, weights())
and
Function BucketWeight(bucket, weights() As Integer)
but I still get #Name?

Sorry these are very basic (ha) questions, but I'm used to C++ and java.

Thanks.

"George Nicholson" wrote:

> > 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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!
>
>
>

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!

> 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" <[email protected]> wrote in message
news:[email protected]...
> 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!

Ah, that might be it, I was defining a whole bunch of functions yesterday and
one of them might have been called "weights". Funny that it was giving the
right answers though. But I mean for weights to be an array of values passed
in to the function, not another function. I'm passing in a chunk of an
excel column. How do you tell VB it's an array? I've tried:
Function BucketWeight(bucket, weights())
and
Function BucketWeight(bucket, weights() As Integer)
but I still get #Name?

Sorry these are very basic (ha) questions, but I'm used to C++ and java.

Thanks.

"George Nicholson" wrote:

> > 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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!
>
>
>