Excel Interop - How to change named range
oRng = oSheet.get_Range("Transactions");
Range namedRange= oSheet.Range[oSheet.Cells[1, 1], oSheet.Cells[3, 3]];
namedRange.Name = "Transactions";