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

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

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

Run this macro:

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

--
Gary''s Student - gsnu200795


"capxc" wrote:

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

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

another way:

ctrl+G

in "Reference" window insert:
1:8000

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

"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


"Gary''s Student" wrote:

Run this macro:

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

--
Gary''s Student - gsnu200795


"capxc" wrote:

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

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

Just tried it. It worked. thanks Jarek.
--
capxc


"Jarek Kujawa" wrote:

another way:

ctrl+G

in "Reference" window insert:
1:8000

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

Another way

Type A1:A1000 in the name box and hit ENTER


Gord Dibben MS Excel MVP

On Thu, 17 Jul 2008 02:48:02 -0700, capxc
wrote:

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?