Sorry about that I have been moving code around trying to fix the situation and I sent the code without this:
They were named as HeaderRows but conflicted with the Motor Parts Header row.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"




Reply With Quote