End of data definition

S

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

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
 
Top