ExcelBanter - How do I delete a partial worksheet?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I delete a partial worksheet? (https://www.excelbanter.com/excel-worksheet-functions/141674-how-do-i-delete-partial-worksheet.html)

Crisco Kid

How do I delete a partial worksheet?

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

Gord Dibben

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?

All times are GMT +1. The time now is 12:58 PM.