Hello, I am using a custom Excel Function which works fine when used manually in the excel file. But when I use the xlswrite to write to a Excel file, it does not work. It throws the "#NAME?" error in the Excel cell. Any idea how to fix it ? I tried the following: * I clicked on the yellow triangle on the left of #NAME and clicked on "Error Checking options". * On the new window called Excel Options, I clicked "Excel Addin": I could see the VBA function under the "Active Application Addin" * I also clicked on "Manage Excel Addin" and clicked on the checkbox VBA_Function(). However, whenever I call the function in the cell, I get an error #NAME?.

Problem using custom VBA function in Excel

2012 4월 27

0 답변

조회 수: 6 (30일)

0 개 추천

Hello,

I am using a custom Excel Function which works fine when used manually in the excel file.

But when I use the xlswrite to write to a Excel file, it does not work. It throws the "#NAME?" error in the Excel cell.

Any idea how to fix it ?

I tried the following:

I clicked on the yellow triangle on the left of #NAME and clicked on "Error Checking options".
On the new window called Excel Options, I clicked "Excel Addin": I could see the VBA function under the "Active Application Addin"
I also clicked on "Manage Excel Addin" and clicked on the checkbox VBA_Function().

However, whenever I call the function in the cell, I get an error #NAME?.