| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error of ClearContents
Hi,
I use ClearContents to reset data before take my calculation on a hidden worksheet. however, the code is get same error. Private Sub CommandButton1_Click() Sheets("Sheet2").Cells.ClearContents End Sub Run-time error '1004': ClearContents method of Range class failed Can someone help me with this? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Error of ClearContents
If you're using XL97, you need to set the button's TakeFocusOnClick
property to False. In article , "Richard" wrote: Hi, I use ClearContents to reset data before take my calculation on a hidden worksheet. however, the code is get same error. Private Sub CommandButton1_Click() Sheets("Sheet2").Cells.ClearContents End Sub Run-time error '1004': ClearContents method of Range class failed Can someone help me with this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sheets("Sheet1").Cells.ClearContents | Excel Discussion (Misc queries) | |||
| "ClearContents" command halts code | Excel Discussion (Misc queries) | |||
| Conditional formatting, pastevalues, clearcontents | Excel Discussion (Misc queries) | |||
| ClearContents method on a passed range | New Users to Excel | |||
| code to clearcontents of "0" values in cells | Excel Programming | |||
![Richard[_23_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
