Hi,
I have a protected sheet with range of cells the user can edit. On the
change event, for each cell in target I restore some formats with a
loop - if it insersect the range of cells allowed.

However, if the user insert a row or column, the code will check all
cells in the column. This is not acceptable, of cource.

However, I want the user to be able to insert rows and columns, so I
can't restrict that together with the sheet protection.

What is the best way to solve this? I don't want to use looping and for
each cell check if it intersect - and if so, Union it to a new range.
Is there any other way?

Happy to all answers,
Regards
tskogstrom