How many rows with Data you have?
If you use Ctrl End in what row are you.

Look here if it is below your last row with data
http://www.contextures.com/xlfaqApp.html#Unused


--
Regards Ron de Bruin
http://www.rondebruin.nl


"hoffman3 " wrote in message ...
The code in the last reply just seemed to freeze up excel, i waited for
5 minutes then finally just restarted it. Thanks for the time though.

Eric Hoffman


---
Message posted from http://www.ExcelForum.com/