I have a spreadsheet with a list of 40,000 account numbers. I can only handle
them in batches of 1000-3000 so I select cell 4000 and hold the mouse as I
scroll to 7000, then I hit copy. When I copy Excel jumps back to the first
selected cell. It's really tedious having to scroll through 3000 accounts
just to have to scroll through the same 3000 again to get to the next batch.

What can I do to stop the jump?

Instead of all that clicking and scrolling, try this.

Press Ctrl+g, then input the range of cells you want.

Or, you can type the range of cells you want directly into the name box (the
box to the left of formula bar)

--
Best Regards,

Luke M
"brainslick" wrote in message
...
I have a spreadsheet with a list of 40,000 account numbers. I can only
handle
them in batches of 1000-3000 so I select cell 4000 and hold the mouse as I
scroll to 7000, then I hit copy. When I copy Excel jumps back to the first
selected cell. It's really tedious having to scroll through 3000 accounts
just to have to scroll through the same 3000 again to get to the next
batch.

What can I do to stop the jump?

Try this idea to see how it works. Then change 20 to 40000 and change 4 to
whatever desired

Sub jumpdown()
For i = 1 To 20 Step 4
Rows(i).Resize(4).Copy
MsgBox i
Next i
Application.CutCopyMode = False
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"brainslick" wrote in message
...
I have a spreadsheet with a list of 40,000 account numbers. I can only
handle
them in batches of 1000-3000 so I select cell 4000 and hold the mouse as I
scroll to 7000, then I hit copy. When I copy Excel jumps back to the first
selected cell. It's really tedious having to scroll through 3000 accounts
just to have to scroll through the same 3000 again to get to the next
batch.

What can I do to stop the jump?

Let's say you want to select A1000:A3000.
In the name box type: A1000:A3000


"brainslick" wrote:

I have a spreadsheet with a list of 40,000 account numbers. I can only handle
them in batches of 1000-3000 so I select cell 4000 and hold the mouse as I
scroll to 7000, then I hit copy. When I copy Excel jumps back to the first
selected cell. It's really tedious having to scroll through 3000 accounts
just to have to scroll through the same 3000 again to get to the next batch.

What can I do to stop the jump?