End of data definition

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Defining a variable length area for output. 2
Filling in today's date against every record 4
Select drop down menu option using libre-calc macro 0
Excel VBA 1
Why is this code not working ? 3
Excel print area which only prints pages of worksheet which are active 0
How to find out when you're getting full fibre internet 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0

Back
Top