maybe this idea will help. Modify to suit
Sub rowstoseletct()
X = InputBox("1st row?")
y = InputBox("lastrow")
Rows(X & ":" & y).Select
End Sub

--
Don Guillett
SalesAid Software

"Katherine" wrote in message
...
Hi,

I have a spreadsheet with almost 10,000 rows that I am going to do a lot
of
sorts and subtotals on. I want to be able to start near the bottom row
but
not the absolute bottom one and and select up to almost the top row but
not
the absolute top. Aside from holding down the left mouse button and
waiting
for it to scroll up all of the rows, is there a shortcut other than
"select
all" to start at one row and have it select everything between that and
another row in one quick step?

Thank you,
Katherine