Sorry about that I have been moving code around trying to fix the situation and I sent the code without this:
Code:
  
 oSheet.Cells(PartSections.PartNumber).Value = "Part Number"
            oSheet.Cells(PartSections.Manufacturer).Value = "Manufacturer"
            oSheet.Cells(PartSections.Description).Value = "Description"
            oSheet.Cells(PartSections.Vendor).Value = "Vendor"
            oSheet.Cells(PartSections.Quantity).value = "Quantity"
            oSheet.Cells(PartSections.Price).value = "Price"
            oSheet.Cells(PartSections.ExtPrice).value = "Ext Price"
            oSheet.Cells(PartSections.Status).value = "Status"
            oSheet.Cells(PartSections.InSock).value = "In Stock"
They were named as HeaderRows but conflicted with the Motor Parts Header row.