View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default How do I delete a partial worksheet?

In namebox type C55:K6500 and ENTER then EditClear Contents.

I realize that is not one action, but one action would require a macro to clear
the contents with the click of a button.


Gord Dibben MS Excel MVP

On Fri, 4 May 2007 20:46:01 -0700, Crisco Kid
wrote:

I have spotted info in many cells from C55 thru K6500. How can I delete all
this in one action?