P
Paul Schrum
Howdy folks,
Sorry about the Newbie question here, but I could not find anything
about this in my web and groups searches.
I am using Excel 2003. I am familiar with VBA programming, but I am
new to VBA programming in Excel.
A few days ago I developed a non-trivial custom function in VBA. I
got it to work and everything was fine. I closed the file, went home,
and slept pretty okay.
The next day I wanted to work in the spreadsheet more. But when I
opened it, all the cells which call my custom function display #NAME.
These same cells worked fine on the same session in which I developed
the function. Can someone tell me what I must do to get the custom
function to work seamlessly -- as if it were just another function
available to all cells in that work book?
TIA
- Paul
Sorry about the Newbie question here, but I could not find anything
about this in my web and groups searches.
I am using Excel 2003. I am familiar with VBA programming, but I am
new to VBA programming in Excel.
A few days ago I developed a non-trivial custom function in VBA. I
got it to work and everything was fine. I closed the file, went home,
and slept pretty okay.
The next day I wanted to work in the spreadsheet more. But when I
opened it, all the cells which call my custom function display #NAME.
These same cells worked fine on the same session in which I developed
the function. Can someone tell me what I must do to get the custom
function to work seamlessly -- as if it were just another function
available to all cells in that work book?
TIA
- Paul