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 |