For whatever reason my worksheet goes on to row 1048576 while actual data
ends on row 204. I tried various methods of deleting rows 205-1048576, but
they won't go away. I enter 205:1048576 into the Name Box and hit Delete, but
the same rows return. It's a vicious circle. I can do this over and over.
Also, hitting Ctrl+Shift+Down takes me down to 1048576, yet hitting Ctrl+End
takes me down to only 504. My worksheet is very screwed up, so I need a
surefire method of absolutely eliminating anything from 205 on. Is this
possible?