Select 100 rows and Copy macro

[Jeffrey Green]

Every week, I have to review a list of 4000 vehicle VINS., I have a column with VINS and I drag down through 100 of them, then copy them, and then paste then in a web portal box to verify them. I can only do 100 at a time. Mildy time consuming to drag down 100 rows, exactly, every time ., . . a macro that started where the cursor is, go down 99 more rows and then COPY, would be great . . .

Thoughts??

Thanks