Error Generating BOM --- Error 91: Object variable or With block variable not set

[the_rizzler]

I get this error when I click the "Generate BOM" button in an Excel Workbook. I'm very new to VBA and Excel and not quite sure what to do here.

 

[the_rizzler]

The "Manufacturer Part No." is different from the "Manufacturer Part Num". The template sheet uses the Num variation while the code seems to be using the No. variant. Maybe this is what is causing the error?
Anyways, thank you so much for helping out thus far, it has been very helpful. I'll be sure to update the thread with a cause and solution once I find it.

 

[Alex Blakenburg]

If you think you can rely on the word "Part" only appearing once in the heading row, you could try using:
lMatPart = .Find("*Part*").Column