Text in a cell is not remaining when inserting a line with VBA

[acoustic_traveller]

Hello,

I,m adding a cell with a macro and with the line I want to add some specific text in some cells. The A column works fine as the date is added but in the Column J the text "en marcha" remains only for the added line. When the new line is added the Text is gone. Any idea how to improve code and solve the issue?

Thank you in advance!
Tavi

[BanginMyHeadOnMyDesk]

Could you attach the workbook rather than a picture of it?
Far easier to help if we can see it in context.

Beth.

[acoustic_traveller]

Could you attach the workbook rather than a picture of it?
Far easier to help if we can see it in context.

Beth.

of course. Here it is. Thx

[Fluff13]

When you insert a new line it's triggering the change event, which then calls macro 1, which in turns clears col J

[acoustic_traveller]

When you insert a new line it's triggering the change event, which then calls macro 1, which in turns clears col J

pffff, now I get it. Thx...

[BanginMyHeadOnMyDesk]

Try this:

Please Login or Register  to view this content.

The 'Application.EnableEvents' lines will temporarily stop the change event from firing when you insert the new line.

Beth.

[acoustic_traveller]

Try this:

Please Login or Register  to view this content.

The 'Application.EnableEvents' lines will temporarily stop the change event from firing when you insert the new line.

Beth.

This is so nice, Thank you Beth

[Fluff13]

Another option, is you can prevent the change event from running if more than one cell is selected like

Please Login or Register  to view this content.