calling VBA function within a worksheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

matelot - 20 Mar 2006 17:11 GMT

When calling a function created in a different workbook, I get the #NAME! not
defined even thought I put down the spreadsheet name.
"=anotherbook!myfunction(A1)"
Am I doing something wrong?

Thanks

Reply to this Message

Trevor Shuttleworth - 20 Mar 2006 17:18 GMT

Is the other workbook open ?

Regards

Trevor

> When calling a function created in a different workbook, I get the #NAME!
> not
[quoted text clipped - 3 lines]
>
> Thanks

Reply to this Message

matelot - 20 Mar 2006 19:45 GMT

Yes.

> Is the other workbook open ?
>
[quoted text clipped - 9 lines]
> >
> > Thanks

Reply to this Message