Hi,
I am using VB.NET and have an app that does a DB query and displays the
results in excel. I want the app to monitor where the results are stored ie.
if the user inserts columns or rows the app still knows where the original
data is stored.

I can use the SheetChange event to monitor when a cell is changed, but I am
unsure about the best way to do this, particularly when the event is fired
for both the cut and paste operations.

Should I 'catch' the cut, store the details of contained cells, then 'catch'
the paste and update my app then?

If so, how can I tell what the user has done? Is there something saved
somewhere to highlight the operation?

Thanks for any help,
Peter.