That didn't work so I copied range a1:m137 and pasted it into a new
spreadsheet.

Now, in the new spreadsheet, when I use 'Go To Special' and click 'Last
Cell', the cursor goes to m137.

You only do cols or rows at a time outside the data area! So if Ctrl+End goes
to p150 then...

Select O:P and Delete
Select 138:150 and Delete
Save the file

This works EVERY TIME unless you do something wrong.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion