User function routines
Posted by Joan Manley on April 27, 2001 5:48 AM
What is the syntax for using a user written function
routine from the VB code attached to the same workbook?
The routines work if I put them into "personal.xls" and
use =personal.xls!fname(a,b,...) in a cell in any
workbook; but I am unable to get them to work when the
VB code is in the same work book.
I have tried
neither of which work as I get a #name error in the
HELP!!!! I know there has to be a way to do this.