What's the question?

Can't you just delete the excess rows?
--
Brevity is the soul of wit.


"Phil" wrote:

I am trying to remove excess rows that don't contain data but have appeared
when the columns were copied from another worksheet. The escess rows slow
down all the processes and make the file size large.