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

[vincentverheyen]

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

[vincentverheyen · Accepted solution]

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):