I suggested this in your other post:

I just tried it and it looks like xl2002 is pretty good at determining the last
used row.

If you hit ctrl-End, do you go way past what you expected? If yes, maybe you
could try some of the techniques at Debra Dalgleish's site to help reset that
last used cell.

http://www.contextures.com/xlfaqApp.html#Unused

If you have formulas that evaluate to "" (so they look empty), then it might be
easier to just copy the range you want and paste to a new worksheet (in a new
workbook) and save it from there.

Laura S wrote:

I am having trouble setting the end of file marker at the end of my
template data. Once I then save as a .prn file to upload to a
mainframe, I get way too many blank lines at the end of my data.
Thanks!

--

Dave Peterson