Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

EXCEL 2002: Change in Calling UserDefined Functions

Status
Not open for further replies.

jofoko

Technical User
Apr 25, 2002
4
AT
Hey,

have there been any changes in calling user-defined functions from Excel 2000 to Excel2002????

The Functions are called via an Add-In from a dll.

It works without any Problems with Excel 97, 2000 but
not with 2002. It generates on Error 1004.

For Example:
Thisworkbook.sheets(1).Range("a1").Formula = "=DB($D4;$E4)"
Where DB is the user-defined function.
This statement is not allowed in 2002.

Why?????

thanks

Jo
 
Could you please provide the DB(params) funtion too?

regards astrid
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top