Hi to All,

In my data Range B4 to AO (last column); in that which column having last row. (example B4 : AO column, compare to others last row in each column; D column having highest 40row then select 40).

Then delete 4th Row to Selected lost row as entire rows delete.

Can anyone suggest Code lines.

Regards, RL