Inserting a new cell without displacing the informations on the sheet

[Geokakis]

I created a data sheet with excel and also wrote a program with VBA code that every changes made on this data sheet is automatically recorded on another sheet indicating the specific cell the changes was made and what value was changed. But the problem is that if a new cell is inserted into this data sheet, it automatically disalign the existing information on the row of the recorded changes sheet.

Can you help

 

[RobBroekhuis]

You're finding out about the limitations of the event handlers in Excel. They work real nice for some things, then they're just not there when you need them for something else. As far as I know, there is no easy way to find out about an insert operation via an event. To do so, you'd almost need to keep an exact duplicate of the worksheet, to compare cell values before and after. A little more work than you're looking for, I'm sure...
Sorry I can't help more helpfully ;-)
Rob