ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   function wizard access violations (https://www.excelbanter.com/excel-programming/290198-function-wizard-access-violations.html)

Janwillem van Dijk

function wizard access violations
 
Hi,
I am writing an Excel addin in delphi/pascal as a .xll file. Works
absolutely great! However, if a function gets more than 12 arguments,
entering the function through the function wizard crashes Excel.
Entering the function by typing in the edit window works fine. All
arguments and the result are of type xlOper (R).

This limitation does not seem to exist for functions programmed in a VBA
module of the workbook.

Is there some parameter that can be adjusted to increase the number of
allowed arguments or is there a work around?

Thanks for any help,
Janwillem


All times are GMT +1. The time now is 09:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com