VBA code

[Shell]

SOme time ago I used some code in VBA to find the last line in spreadsheet.
Two questions.
1. Does anyone know where I can get the code?
2. How can I use this code in Pivot table?

I am using Excel 2000

THANKS