ExcelBanter - VBA code

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - VBA code (https://www.excelbanter.com/excel-discussion-misc-queries/151974-vba-code.html)

Shell

VBA code

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
--
Shell

All times are GMT +1. The time now is 06:43 PM.