What's the command to select row 1 to 8000 out of table of 24000 r

[capxc]

How do I put a command so that i could select row 1 to row 8000 in a table
that have more than 24000 row? The purpose is that I want to be able to
select a specific portion of the whole table without having to drag the
cursor all the time. Anybody knows?

 

[Gary''s Student]

Run this macro:

Sub row_your_boat()
Rows("1:8000").Select
End Sub

 

[Jarek Kujawa]

another way:

ctrl+G

in "Reference" window insert:
1:8000

 

[capxc]

"Sub row_your_boat()"

Hi Gary,

Sorry, I am not very techie. I have to confess that I do not know what it
means to :
'enter macro'
'sub row your boat'.
Can you guide me please?

 

[capxc]

Just tried it. It worked. thanks Jarek.

 

[Gord Dibben]

Another way

Type A1:A1000 in the name box and hit ENTER


Gord Dibben MS Excel MVP