Range change when adding a column

[Apa2022]

Hello, I have a formula like Range("A" & LastRows, "M" & LastRows)
If I add a column to the file, why the new formula Range("A" & LastRows, ,"N" & LastRows) will break the macro and stops running?
The macro does a loop, autofilter data , copy paste the data filtered in a sheet. But after changing the range, the macro does not run correctly. Could you help me please? Thank you

 

[BSALV]

it's difficult to predict how to change your macro, because you have to see the macro.
You can start to give the column N or the cell N1 a name ("Named Range") and as you insert a column, you can refer to that named range to use the bigger new range

 

[Apa2022]

Hello, thank so much for your reply, could I send you the macro so you could give me an idea?
Thank you

 

[Fluff]

You can simply post the macro to the thread. How to Post Your VBA Code