Problem using custom VBA function in Excel
조회 수: 1 (최근 30일)
이전 댓글 표시
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?.
댓글 수: 0
답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Data Export to MATLAB에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!