How to handle resize of range upon insert column/row in Excel via VSTO

Question

Hi all,

I'm working on an Excel add-in and have an issue with ranges.

Suppose we have a range on a spreadsheet - A1:D1. A user inserts a column at say column C. My VSTO Range object is still A1:D1 but I'd like it to become A1:E1.

UPD: I don't expect this to happen automatically, but I wonder is there a way VSTO would help me to implement this behavior.

Before column inserted I have this:

 A   B   C   D
[1] [2] [3] [4]
 |===========|   

After insertion I want to have this:

 A   B   C   D   E
[1] [2] [ ] [3] [4] 
 |===============|

But not this

 A   B   C   D   E
[1] [2] [ ] [3] [4] 
 |===========|

Is there a way to do this using C# and VSTO?