Disable macro when inserting/deleting rows

Thanks, I can now insert the rows fine, but I realize now the code doesn't fire afterwards? This is my code after the modification. I had a second portion of the code in another IF statement that worked fine previously.

Please Login or Register  to view this content.

I apologize for not being more clear. I have columns A-I and about 2000 rows of information. User inputs information in columns A,B, & F. Those are blank slots until they fill in the information. Columns C, D, G-I have formulas within them. I want the formula to carry down if they insert rows because of changing situations (2nd IF statement). However, if they change anything in column F, I want column E to record when they changed it (1st IF statement). So both macros need to be running concurrently in the background.

I can't attach the file for some reason right now.

If I just put in the break anywhere, then nothing works. I put the Application.EnableEvents = true after the final IF statement but then it applies the change to every cell in that row from A to IV.

Please Login or Register  to view this content.

I fixed the code back to the original format. Sorry for the switch. I know sometimes the logical flow of the statements can make it work or not, but it still doesn't. I have attached a sample file on. Has things for the first 50 or so rows. Same problems still crops up though in that if I add a row or delete a row, it will time stamp everything in that row.

I believe so. For some reason only one IF statement will work at each time. It just needs to carry the formula down if a row is inserted and record a change in column F when it happens. When I debug it right now, it highlights the

'next cell' line.

It still keeps on time stamping every cell in the row that is inserted.

I believe so. Before I inserted the time stamp function, it worked properly, albeit a bit laggardly.

As something gets entered into any cell in column F, or in this case, F3, it should give a time stamp in E3. Same goes for F4 -> E4, F5 -> E5 etc.

The problem is right now is that inserting a row in row 2, the code will not execute properly and either give an error without the break statements, or will post the time stamp in every cell in that row with the time statement.

In addition, there are referencing formulas in columns C,G,H, I that need to be carried down if a row is inserted.

The non-execution is weird. It happens only after I terminate the macro. I would need to reopen the file again before it runs again.

Is there a way to code it as, if I am inserting row, there will be no time stamp, but the formulas will carry down?

Thanks, it works great! Thanks again for all your help.

Thanks again