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