End of data definition

[Surfstiling]

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?

[Gord Dibben]

You could hide the unused rows and columns and set that as a View>Custom View
you could select whenever you wish.

CTRL + Home and CTRL + End will find A3500 and X15000

OR you could set the scrollarea via macro.

Sub ScrArea()
Sheets("YourSheet").ScrollArea = "A3500:X15000"
End Sub


Gord Dibben Excel MVP


On Thu, 24 Mar 2005 16:35:04 -0800, "Surfstiling"
<Surfstiling@discussions.microsoft.com> wrote:

>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?