Thread: Clean/delete all cells outside of a range
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
GS[_6_] GS[_6_] is offline
external usenet poster
  
Posts: 1,182
Default Clean/delete all cells outside of a range
Cells in range a1:m137 contain data.

But, when I use 'Go To Special' and click 'Last Cell', the cursor goes to a
cell outside of range a1:m137.

How do I clear/delete all cells outside of range a1:m137?

Select entire cols and/or rows, Delete both, then Save.

--
Garry

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