I have forgotten how to define an area of a worksheet as the end of file. I
basically have 30,000 to 40,000 records but want to define different area as
the end and home cells. IE if A1 to X40,000 is the data, I want to assign
A3,500 as the home and X15,000 as my end while I work with this data.

Any ideas?