What happens if you hit <End<Home? Let' say your last entry is in G213.
Does the cursor go to say K421? If this is the case, delete all rows from
214:421, and then delete all columns from H:K. Save your file and hit
<End<Home again. It should now go to G213. If so, it should only print up
to row 213 as well.

--
Hth

Kassie Kasselman


"ranger1701" wrote:

I am merging several worksheets on only want to print upto the point data is
entered. Its a log, and I only need the lines to print up to the last log
entry. Its need to be set up so that the users of the sheet only hit the
print button. Its all they can do.