I used the 1st option (automatic vs. user) and it gets stuck at: If .Cells(.Rows.Count, i).End(xlUp).Row > LastRow Then

The tab is not protected and I did updated the ColNum and LastRow

Any ideas why?