How to call VBA function from Excel cells (2010)?
Answer Putting the function in the “ThisWorkbook” area can cause the #NAME? problem. Create a new Module (Right Click on the VBAProject Folder, Insert, New Module) and put the function there instead. Steps Open the VBA Editor (Alt + F11 on Windows / Fn + Option + F11 on a Mac) Right-click VBAProject Select Insert … Read more