I have a problem when I am trying to clear all of the data off of a
worksheet except the Header rows. For example I may to clear any row after
#7 of all data, I've been using the range A7 to Z55500 EntireRow.Delete

BUT

Once I've copied the new records to that worksheet and want to loop through
them the count Range is really really high 55500+ and includes thousand of
blank rows. How can I clear a work sheet without messing up the used range?