Seigna, I am afraid you are misunderstanding how the code works. Columns.Count just produces a count of total number of columns (it doesn't decide the starting point), in this case it returns 11. So nb_Actions when you use it in the code would be 11 but you have a minus 1 at the end and so this means it is now the number 10.
It doesn't decide the Column to start at.
What decides the Column to start at in your code is the second 2(in red) in the line below.
So basically it is now saying
Row2,Column2 to LastRow,Column((11-1)+1)
if you change that second 2 to a 1 i.e.
It will only select up to Column J but start at Column 1
Bookmarks