View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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