Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2006
    Posts
    47

    Unanswered: if i have a function in personal mod Financial how can i use in wks?

    in my personal.xls file i have a module Financial in financial i have a function Interpolate in my xl file i would like to wright in cell a1 =Interpolate(b1,b2,c1,c2,c3)

    this will work when interpolate is in module1 of the book i am in at the time (book1.xls) but when i put the function into my personal workbook in module financial it no longer works

  2. #2
    Join Date
    Apr 2006
    Posts
    47
    what i did was use the fx (function wiz) near the formula bar, then i selected user defined from the cat cbo and it showed how to ref my func

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •