electricpete
Technical User
I am able to put macros (subs without arguments) in my personal.xls file, and they are available for running in any spreadsheet via the Tools / Macro / Run menu.
But when I try to invoke a function from my personal.xls, I get an error #name?
Why is it that a workbook can pull a sub from another workbook (personal.xls), but a workbook can't pull a function from another workbook?
The function is:
Public Function getformula(mycell As Range) As String
getformula = mycell.Formula
End Function
That function is declared in module1 (a standard module) of my personal.xls. Right below it is a macro subroutine which runs fine.
But when I try to invoke a function from my personal.xls, I get an error #name?
Why is it that a workbook can pull a sub from another workbook (personal.xls), but a workbook can't pull a function from another workbook?
The function is:
Public Function getformula(mycell As Range) As String
getformula = mycell.Formula
End Function
That function is declared in module1 (a standard module) of my personal.xls. Right below it is a macro subroutine which runs fine.