Home |
Search |
Today's Posts |
#1
|
|||
|
|||
End of data definition
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? |
#2
|
|||
|
|||
You could hide the unused rows and columns and set that as a ViewCustom 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" 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Charting data ranges that change | Charts and Charting in Excel | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |