| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
clear the entire active worksheet
how to clear the entire active worksheet at once?! I need something like,
Range.ClearContents() which is for a particular range of cells on excel. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
clear the entire active worksheet
Cells.Clear
-- Gary''s Student - gsnu200826 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
clear the entire active worksheet
Try,
ActiveSheet.UsedRange.ClearContents Mike "NA_AB" wrote: how to clear the entire active worksheet at once?! I need something like, Range.ClearContents() which is for a particular range of cells on excel. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
clear the entire active worksheet
hey guys, thanks you both! :) the question was very trivial one, am a new bie
though. thanks again! "Mike H" wrote: Try, ActiveSheet.UsedRange.ClearContents Mike "NA_AB" wrote: how to clear the entire active worksheet at once?! I need something like, Range.ClearContents() which is for a particular range of cells on excel. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting of Entire Row when the Active Cell is in ro | Excel Discussion (Misc queries) | |||
| Clear entire rows below last row of data in col A except in 1st 3 sheets | Excel Programming | |||
| how to scroll through active cells instead of entire worksheet | Excel Discussion (Misc queries) | |||
| Making Hyperlinks Active In Entire Column | New Users to Excel | |||
| Clear contents of unprotected cells in entire workbook with a macr | Excel Programming | |||
![NA_AB[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
