Ok dave I further explain, this function of vb code I wrote in VB editor
(Insert module then write code then save as add-ins and named it to
personal.xla in Add-ins directory),now when I create a new worksheet file and
use it this formula it work fine but when I use this formula in my an
existing worksheet it display #name? error, I didn't understand same formula
works in new file but don't work in old file. I don't know what I'm doing
wrong as I'm new to vb code & I learned this function from MS help in custom
user defined functions.

"Dave Peterson" wrote:

It hasn't clarified the issue for me.

I'd go back through the suggestions and try them one more time.

And maybe you could explain your original post one more time:

====
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
====


Does this mean it works in new sheets in existing workbooks?

What are you trying to replace the formulas with?

What was the existing formula and what are you replacing them with?

Samad wrote:

I checked again there is no define name or any module & one thing more, the
same problem I'm facing with other functions like

Function adminsc(gp)

If (gp * 0.05) = 2000 Then
adminsc = 2000
Else
adminsc = gp * 0.05
End If

End Function

hope it clarifies, Thanks for taking interest.

"Dave Peterson" wrote:

I didn't want you to define a name. I wanted you to check to see if there was a
defined name already there that was causing confusion.

And one more guess. Do you have any modules in the project named Markup? If
you do, try renaming it to Mod_Markup.

Samad wrote:

Thanks Dave, but "the internet explorer was not able to open this internet
site" when I download "namemanager.zip" file anyway can you further define me
where & why should I define name; this is a small formula that I want to put
in various sheets that's why I put it on add-ins named personal.xla so that I
can use it as =markup(principal,rate,days) or =markup(500000,5%,79). thats it.

"Dave Peterson" wrote:

Any chance that those existing workbooks have a name called Markup?

Insert|Name|define to check

or Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name Manager:
NameManager.Zip from http://www.oaltd.co.uk/mvp

Samad wrote:

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

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson