I have a Excel Add-In that is a .xlam and has a module in it. I am needing to add to that module and manipulate a worksheet. If I test my syntax in a standard workbook standard module it works as expected, but the second it is added into the add-in syntax it stops behaving the way that it should.
Issues with synatx:
1) Pop-up asking where Sheet named Helper is (it is a sheet in the open workbook, verified name was exactly right, no whitespace)
2) Unable to write to sheet that is saved in add-in (again verified name is exactly right, no spaces or whitespace etc)
Syntax - to access the worksheet that is in the add-in I use this
No error is thrown there, but the second I try to write to it like this, nothing is ever written to the sheet.Please Login or Register to view this content.
Display of issue with accessing data on active worksheet the sheet that is visible in the workbook, if I try to use a quick count to get the last row an error is thrown that says application defined or object defined error.Please Login or Register to view this content.
How can I use a macro from an addin to access & modify sheets in the workbook/add-in?Please Login or Register to view this content.
Bookmarks