Refer the topic by Debra

Search for "To manually reset the used range: " in the below link

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

If this post helps click Yes
---------------
Jacob Skaria


"Perplexed of Worcs" wrote:

I'm cutting a larger Excel file into 2 smaller ones, and then converting to
csv. The original but now smaller file shows empty lines when converted,
which causes a problem for the resultant application. Rather than cut and
paste this into a new Excel file, can anyone tell me how to resolve these
empty, but apparently 'in use' cells/rows?