Alright, we all know how to do this. How do I put it into code?
This is what my employer told me.

1. go to the column B
2. hit <end <down and it goes to the last student.
3. hit <Down arrow once more (puts cursor below last active record).
4. Select EVERY row from there to <end<Down (bottom of exce
sheet)
5. <right click and DELETE


How on earth do I do this in VBCode

--
Zlor
-----------------------------------------------------------------------
Zlord's Profile: http://www.excelforum.com/member.php...fo&userid=2751
View this thread: http://www.excelforum.com/showthread.php?threadid=48028