How does one go about expanding a defined Excel Range? I have it defined as:
Code:
Dim TempRange As Excel.Range = Globals.Sheet1.Range("E4:P4")
Now what I want to do is add items into that range. In actuality, I need to add "P4" at the beginning, and "E4" at the end of TempRange, keeping all of the items in the original TempRange as well (two items on top of the total cells in TempRange). Is there an easy way to assign an array of values and put it back into an Excel.Range object?

Using VS 2008, Excel 2007, VSTO.