View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default User Defined Function

Did you install the add-in or just load it like a spreadsheet?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Samad" wrote in message
...
I put some vb code to a add-ins file that create markup i.e

Function markup(principal, rate, days)
markup = principal * rate / 365 * days

End Function

it works fine in new sheets but whenever I try to replace the formulas in
existing sheets it display #name? error.
can someone help me what I'm doing wrong or is it a formatting problem

Thanks in advance