Delete Entire Row Range

[rr1050]

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

[jewelsharma]

try this:

Please Login or Register  to view this content.

HTH!

[Hawkeye16]

Untested, but something like this

Please Login or Register  to view this content.

[rr1050]

thanks both code only delete one line.
My requirement is complete entire rows. For above example, 4th to 40th row, entirely delete it.

Also, B4 to AO require to find column which having last row. & then Entire Rows Delete in One Go!

[jewelsharma]

try this:

Please Login or Register  to view this content.

If this doesn't work, it would be helpful if you share your workbook.

[rr1050]

Now it is very great! Thanks jewelsharma.

It works good!

[Hawkeye16]

I see. Mine deleted every 4th row to the last row as that is how I interpreted your original post


Sent from my iPhone using Tapatalk

[jewelsharma]

I read it as deleting only the 4th row from the last row in the first instance.