You mean there are 6 heading rows in every 51 rows? Are the heading rows
the same distance apart throughout the file? Is there anything unique about
the heading rows (such as text in a column that normally has numbers)?

"Lost in Microbiology" wrote
in message ...
I have an imported text file from a lab system that has a header every 51
rows.

I would like to create a macro that deletes 6 rows every 51 rows, but
can't
figure it out, please help. Thanks.