cancel
Showing results for 
Search instead for 
Did you mean: 

VBA hookup error Type mismatch "idxWhat = Application.Match("ABCID", headers, False) + addColumn"

vincentverheyen
Active Participant
0 Kudos

After installing "SAP_IBP_VBA_Hook_2005_and_Later_versions.xlam" as per 2421657 - SAP IBP, Add-In for Microsoft Excel / Implementation of VBA Hooks to extend functionality ..., when opening a Master Workbook sheet "Products", I receive the following error:

Microsoft visual Basic
Run-time error '13':
Type mismatch



Debugging leads to the following



idxWhat = Application.Match("ABCID", headers, False) + addColumn
Value of idxWhat equals 0


When trying to close the Master Data Workbook

Accepted Solutions (1)

Accepted Solutions (1)

vincentverheyen
Active Participant
0 Kudos

The problem is that there is no header "ABCID" in your Master Data Workbook sheet "Product". Retry with UNIPA planning area, which does include the Attribute "ABC Code" (the VBA code looks for the attribute ID which is ABCID):

Answers (0)