| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
calling VBA function within a worksheet
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
calling VBA function within a worksheet
Is the other workbook open ?
Regards Trevor "matelot" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
calling VBA function within a worksheet
Yes.
"Trevor Shuttleworth" wrote: Is the other workbook open ? Regards Trevor "matelot" wrote in message ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calling worksheet function from a macro | Excel Worksheet Functions | |||
| calling a function | Excel Programming | |||
| Calling Function | Excel Programming | |||
| calling a function in a worksheet from a user form | Excel Programming | |||
| Calling a different worksheet??? | Excel Programming | |||
Hybrid Mode
