-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Clear data by clicking command button
Excel Facts
Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
Re: how to clear data by clicking command button
To clear A2:AD150 that is located on the active sheet, try...
To clear A2:AD150 that is located on another sheet (ie. Sheet2), try...
To clear just the contents, replace Clear with ClearContents.
Hope this helps!
To clear A2:AD150 that is located on the active sheet, try...
Code:
Range("A2:AD150").ClearTo clear A2:AD150 that is located on another sheet (ie. Sheet2), try...
Code:
Worksheets("Sheet2").Range("A2:AD150").ClearTo clear just the contents, replace Clear with ClearContents.
Hope this helps!
Upvote
0
Re: how to clear data by clicking command button
hey i want to clear only values, and formulas in those range..your code clearing format too
To clear A2:AD150 that is located on the active sheet, try...
Code:Range("A2:AD150").Clear
To clear A2:AD150 that is located on another sheet (ie. Sheet2), try...
Code:Worksheets("Sheet2").Range("A2:AD150").Clear
To clear just the contents, replace Clear with ClearContents.
Hope this helps!
hey i want to clear only values, and formulas in those range..your code clearing format too
Upvote
0
Similar threads
- Question
- Replies
- 1
- Views
- 27
- Replies
- 7
- Views
- 145
- Solved
- Replies
- 10
- Views
- 183
- Replies
- 0
- Views
- 49
- Question
- Replies
- 4
- Views
- 238
